Thread
:
Pivot Chart trendline
View Single Post
#
2
Posted to microsoft.public.excel.charting
Tushar Mehta
external usenet poster
Posts: 1,071
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
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta