Pivot Chart trendline
 

Is it possible to add a trendline to the Pivot Chart? I cannot find it
anywhere...
Thanks in advance.

Pivot Chart trendline
 

In article ,
says...
Is it possible to add a trendline to the Pivot Chart? I cannot find it
anywhere...
Thanks in advance.

That would depend on what kind of a PivotChart you have. Trendlines are not
supported for certain types of charts including the default PivotChart,
which is stacked column chart. Change the chart type to one that supports
trendlines (say a clustered column) and you can add one to a PC. But,
chances are you will lose it whenever the PC (or PT) is recalculated. For
some more on the subject see the XL help topic 'About forecasting and
showing trends in charts' particularly the section titled 'Chart types that
support trendlines.'

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions