Plot a graph with grand total data from pivot table

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.