Microsoft Office Tutorials and References
In Depth Information
With Excel, you can add trendlines to your charts.
Trendlines help you see both the size and direction
of changes in your data and you can use them to
forecast future or past values based on available data.
By creating a trendline, you can answer questions
such as, “Is there a pattern in the recent surge of
You can add a trendline to any chart type except
3-D, stacked, radar, pie, surface, or doughnut charts.
Excel superimposes the trendline over your chart.
A trendline is the line through your data series that is
as close as possible to every point in the data series.
Excel provides the following trendline types: linear,
logarithmic, polynomial, power, exponential, and
moving average. The type of trendline you choose
should be based on the type of data you have. Excel
generates a statistic called R-squared that indicates
how well a given trendline fits your data. The closer
R-squared is to 1, the better the line fits your data.
You can choose to have the R-squared value appear
on your chart.
Click your chart.
The Chart tools become
Click the Layout tab.
Click Trendline in the Analysis
A menu appears.
Click More Trendline Options.
Alternatively, click a menu
option to choose the type of
trendline you want to apply.
l The Format Trendline dialog box
Click Trendline Options.