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.

Linear trendlines

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: