Add Trendline to Pivot Table Graph

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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.
 
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
 
Back
Top