Cool Add Trendline Excel Chart
Select the chart in which you want to add the trendline.
Add trendline excel chart. Select the chart click the Chart Elements button and then click the Trendline checkbox. Excel makes adding a trend line to a chart quite simple. You can add a trendline to an Excel chart in just a few clicks.
Now the horizontal average line is added to the selected column chart at once. Ad Transform Data Into Interactive Charts. Use the INTERCEPT function to calculate the point at which the line will intersect the y-axis.
Kutools for Excel - Includes more than 300 handy tools for. You can either open Excel from your Applications folder then click File Open or you can right-click the project file in Finder and click Open with Excel. Excel displays the Trendline option only if you select a chart that has more than one data series without selecting a data series.
Select the column chart and click Kutools Charts Add Line to Chart to enable this feature. Doubleclick on the trendline to open the settings pane. Get Your Free Trial.
In the Add line to chart dialog please check the Average option and click the Ok button. On the Chart Design tab in the Chart Layouts group click the Add Chart Element drop-down list. Select the Trendline option.
Please note that the Trendline will be removed when select None from the list. Another quick way to add trendline to an Excel chart is to right-click the data series and then click Add Trendline. Click Add Chart Element in the Chart Layouts area.