O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding Trend Lines

A trend line is a line that describes the general tendency of a data series. It can be a moving average, a linear-regression line, or a line generated by one of various kinds of nonlinear curve-fitting methods.

To add a trend line to a series in an area, bar, column, line, or xy (scatter) chart, first select the series, and then choose Chart, Add Trendline. (This command appears only when a series is selected.) Excel displays the Add Trendline dialog box shown in Figure 26-12.

Using the Add Trendline dialog box, you can add six different types of trend lines to your data series.

Figure 26-12. Using the Add Trendline dialog box, you can add six different types of trend lines to your data series.

To specify how Excel should draw the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required