Microsoft Office Tutorials and References
In Depth Information
Adding a trendline to a chart
Adding a trendline to a chart
You can use the data in your Excel workbooks to analyze past
performance, but you can also have Excel make its best guess as
to future performance if current trends continue. For example,
if you create a chart that represents your company’s sales for
the past five years, you can have Excel analyze the data and
add a trendline to the chart to represent how much sales would
increase if the current trend holds true for the next year.
Add a trendline to a data series
1 Click the chart to which you want to add a trendline.
2 Click the data series to which you want to add a trendline.
3 Click the Chart Elements button.
4 Position the mouse pointer over Trendline.
5 Click the gray triangle that appears.
6 Click Linear.
TIP If you want more control over your trendline, such as by
choosing a different mathematical procedure to extend the line
(although the default Linear option works the majority of the time) or
by choosing the number of units by which to extend the line, click the
gray triangle next to Trendline and then click More Options to display
the Format Trendline task pane.
CAUTIoN Unless you’re working with certain types of
scientific data and you know that your trendline requires a
logarithmic, exponential, or other regression type, select the Linear
Trendline option. If you don’t, you won’t get meaningful results.
Search JabSto ::

Custom Search