Add Trendline to Pivot Table Graph

[Guest]

I have a list of survey responses and I have created a Pivot Table with Month
as the Row Heading and Count of Respondent as Data. I have then created a
Pivot Table chart.

I want to show a trendline but when I select the columns and right click for
Trendline, as I would normally, the option is greyed out.

How do I create a trendline for the pivot table category columns?

 

[Jon Peltier]

If Add Trendline is disabled with a pivot chart (I don't know, I rarely make
pivot charts), you could plot the data in a regular chart, then add your
trendline.

Pivot Tables, Pivot Charts, and Real Charts
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553

- Jon

 

[Guest]

Thanks Jon - Disappointing but at least I know!

If Add Trendline is disabled with a pivot chart (I don't know, I rarely make
pivot charts), you could plot the data in a regular chart, then add your
trendline.

Pivot Tables, Pivot Charts, and Real Charts
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=553

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

 

[William]

Hi Mary Ann

Is your graph a "stacked" column? If so, change it to a different style (eg
clustered column) and you should get what you are looking for.
--

Regards

William

XL2003

(e-mail address removed)


|I have a list of survey responses and I have created a Pivot Table with
Month
| as the Row Heading and Count of Respondent as Data. I have then created a
| Pivot Table chart.
|
| I want to show a trendline but when I select the columns and right click
for
| Trendline, as I would normally, the option is greyed out.
|
| How do I create a trendline for the pivot table category columns?

 

[Guest]

Fantastic – even though the chart doesn’t look like a stacked column, because
I just have one column for each month, in fact as far as Excel is concerned I
can now see that that is what it is. Thank you.

 

[scamquist]

Add a grand total to the table
Include the grand total in your stacked graph range
Select the grand total series and plot the series on secondary axis
Change the grand total chart type to line (no markers)
Select the grand total line series, right click and add trend line
Select the grand total line series, right click and format the series - Line Color = No Line
Remove header name from table
Select the secondary axis and delete it