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 |