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?