G Guest May 2, 2007 #1 when i make a chart from a pivot table, the "add trendline" option under "charts" is greyed out. How do I add the trandline?
when i make a chart from a pivot table, the "add trendline" option under "charts" is greyed out. How do I add the trandline?
J Jon Peltier May 2, 2007 #2 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
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
