Microsoft Office Tutorials and References
In Depth Information
Figure 17-23: Use the Format Trendline task pane to fine-tune trendlines.
Figure 17-24 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.
The workbook used in this example is available at this book's website. 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:
y = 53.19x + 514.9