| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot Chart trendline
Is it possible to add a trendline to the Pivot Chart? I cannot find it
anywhere... Thanks in advance. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding additional data to a pivot chart | Charts and Charting in Excel | |||
| Pivot Chart Help! | Charts and Charting in Excel | |||
| Pivot Chart - Remove Variables | Charts and Charting in Excel | |||
| Preserve formatting in Pivot Chart | Charts and Charting in Excel | |||
| Pivot chart issue | Charts and Charting in Excel | |||
Linear Mode
