Thread
:
Add Trendline to Pivot Table Graph
View Single Post
#
5
Posted to microsoft.public.excel.charting
Mary Ann
external usenet poster
Posts: 31
Add Trendline to Pivot Table Graph
Fantastic €“ even though the chart doesnt 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.
"William" wrote:
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
"Mary Ann" wrote in message
...
|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?
Reply With Quote
Mary Ann
View Public Profile
Find all posts by Mary Ann