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 the same results for data you don't summarize within a PivotChart.…