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?

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?