| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
ADDING A TRENDLINE WHEN MAKING A CHART FROM A PIVOT TABLE
when i make a chart from a pivot table, the "add trendline" option under
"charts" is greyed out. How do I add the trandline? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
ADDING A TRENDLINE WHEN MAKING A CHART FROM A PIVOT TABLE
The default pivot chart type is a stacked column chart. Stacked charts do
not support trendlines. Convert to an unstacked chart type (clustered column or line) to enable trendlines in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "leo" wrote in message ... when i make a chart from a pivot table, the "add trendline" option under "charts" is greyed out. How do I add the trandline? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Trendline to Pivot Table Graph | Charts and Charting in Excel | |||
| Pivot Chart trendline | Charts and Charting in Excel | |||
| Trendline in pivot table | Excel Discussion (Misc queries) | |||
| Adding Trendline To Just Some of the Bars in Chart | Charts and Charting in Excel | |||
| Where is the "Chart Menu" for adding a trendline to a set of #s? | Charts and Charting in Excel | |||
Linear Mode
