Steps to Add a Business Trendline to PivotChart


show more Adding a trendline to a PivotChart provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Adding a trendline to a PivotChart

When you analyze data using a PivotChart, you must pay close attention to the individual values in your datasets. Even so, it's often beneficial to take a step back and look at the overall trends in your data. You can enhance your analysis by projecting future values, assuming current trends stay constant, by adding a trend line to your PivotChart. To create a PivotChart trend line, you can click the PivotChart and then on the Layout contextual tab, click the Trendline button and then select the type of trend line that you want to create.

So in this case I'll click a Linear Trendline, which creates a line that best fits the data that's displayed within the PivotChart. Now the trend line only exists within the chart and the Excel program memory. It doesn't actually add data to your worksheet, and I should also point out that Excel uses linear regression techniques to create the trend line. These techniques are also implemented in the Forecast function. So you can generate...

Adding a trendline to a PivotChart
Video duration: 2m 22s 3h 43m Intermediate

Viewers:

Adding a trendline to a PivotChart provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...