add chart trend line to excel for mac 2016

You can modify their look to emphasize your data, and you can style the chart title and value label text differently to make it stand out from the other text.

Add a legend Click the chart, then in the Format sidebar, click the Chart tab.

In your spreadsheet, click the legend to select it, then do any of the following: Change the look of the legend text: Click the Style tab at the top of the sidebar, then use the controls to add a background fill, add a border, and more.

Resize the legend: Drag the square handles around the legend.

You can position the legend more precisely by selecting it, then pressing the arrow keys on your keyboard.

Modify axis gridlines You can specify whether to show chart gridlines and modify their look.

Click the chart. In the Format sidebar, click the Axis tab, then click the button for the axis you want to modify (x or y).

Do any of the following: Set the line type: Click the disclosure triangle next to Gridlines (for the x axis), or Major Gridlines or Minor Gridlines (for the y axis), then click the pop-up menu and choose a line type.

Set the line color: In the Major Gridlines section, click the color well or color wheel, then choose a color.

Set the increment for major gridlines: In the Major Gridlines section, click the arrows to the right of the increment field, or type a value in it.

Show tick marks for the x or value axis: Click the Tick Marks pop-up menu, then choose a location.

Show or remove reference lines You can add reference lines to a chart to mark the average, median, minimum, and maximum values in the chart or another value that you specify.

Reference lines make the chart easier to comprehend at a glance and can help you compare the values in the chart to a benchmark value.

All chart types can have reference lines except stacked charts, 2-axis charts, 3D charts, pie charts, and donut charts.

Click the chart. In the Format sidebar, click the Axis tab, then click the Value button near the top of the sidebar.

Click the disclosure triangle next to Reference Lines, then choose any of the following types of reference lines from the pop-up menu: Average: A line that runs through the mean value of the data Median: A line that runs through the middle value of the data Minimum: A line that runs through the lowest value of the data Maximum: A line that runs through the highest value of the data Custom: A line that runs through the value you specify To show what the reference line represents, select the Show Name and Show Value checkboxes.

To change the settings for a reference line, click the line, then use the controls in the Reference Line tab in the sidebar on the right.

To remove a reference line, click the line to select it, then press Delete on your keyboard.

Note: When you drag the slider on an interactive chart to view different data sets, its reference lines move.

Show or remove error bars Error bars give you a general impression of your datas accuracy.

Theyre represented as small marks whose length indicates the amount of uncertainty associated with a given data series (the datas variability).

You can add them to 2D line charts, area charts, bar and column charts, stacked bar and column charts, bubble charts, and scatter charts.

Click the chart, then in the Format sidebar, click the Series tab.

Click the disclosure triangle next to Error Bars, then click the pop-up menu and choose a type of error bar.

Add Chart Trend Line To Excel For Mac 2016