Add Trendline To Existing Graph In Excel 2016 For Mac

Add Trendline To Existing Graph In Excel 2016 Series And Do#

Add Trendline To Existing Graph In Excel 2016 Series And Do

: The type of trend line that you choose depends. To add a trendline, select the data series and do one of the following: Under Chart Tools, on the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose Trendline list: In the popup menu select Add Trendline. Excel makes adding a trend line to a chart quite simple.

However, if you graph is chronological or time series based you need to pick a complementary chronological data. However, you still can by simply clicking Edit Legend Series and choosing X values. The Edit Series window will open up, then you can select a series of data that you would like to change.For a time series like months, when you click select data you will not have the option to directly edit the x-axis. Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Edit3.

From the image below, you can see that this graph is based on the index column and the Selected Period column. But essentially the steps are the same.Follow the visuals instructions below or watch the video:Create a graph. Also, you can directly change x values from Select Data Source window.

Add Trendline To Existing Graph In Excel 2016 For Mac