Microsoft Office Tutorials and References
In Depth Information
Working with Trendlines
When Excel inserts a trendline, it may look like a new data series, but it’s not. It’s a new chart
element with a name, such as Series 1 Trendline 1. And, of course, a trendline does not have a
corresponding SERIES formula.
Figure 17-23 shows two charts. The first chart depicts a data series without a trendline. As you
can see, the data seems to be “linear” over time. The next chart is the same chart but with a
linear trendline that shows the trend in the data.
Figure 17-23: Adding a linear trendline to an existing chart.
The workbook used in this example is available on the companion CD-ROM. The file is
named linear trendline.xlsx .
The second chart also uses the options to display the equation and the R-squared value. In this
example, the equation is as follows: