Plot a graph with grand total data from pivot table

Hi How can I make a graph showing total attendance (grand total) data from a pivot table, so I can show how total attendance changes over time? Thanks

Charts & Visualizing Data

Need Help

Dave Belcher
Nov 26, 2017
Hi Detlef

Thanks.

I have found a fix to the issue. If you insert pivot table chart it wont let you select total rows.

But if you go to insert tab, and insert only 'normal' chart, you can modify your data to be the rows you want, e.g. dates and count of students as I wanted.

So the answer is, don't bother with a pivot chart. Although I am not sure what the difference is between the two types of chart.

Detlef_Lewin

Silver Contributor

Nov 23, 2017

Dave,

maybe I got it wrong. It's difficult understand from a photo.

Please provide a sample workbook.

Dave Belcher

Brass Contributor

Nov 26, 2017

Hi Detlef

Thanks.

I have found a fix to the issue. If you insert pivot table chart it wont let you select total rows.

But if you go to insert tab, and insert only 'normal' chart, you can modify your data to be the rows you want, e.g. dates and count of students as I wanted.

So the answer is, don't bother with a pivot chart. Although I am not sure what the difference is between the two types of chart.

Forum Discussion

Plot a graph with grand total data from pivot table