Nov 21 2017
- last edited on
Jul 25 2018
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?
Nov 23 2017 07:11 PM
Thank you. Perhaps I am missing something, but if I want to plot x axis dates, and y axis total number of attendees, wouldn't I need the dates in the pivot table?
Nov 23 2017 07:28 PM
maybe I got it wrong. It's difficult understand from a photo.
Please provide a sample workbook.
Nov 26 2017 09:13 PMSolution
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.
Nov 04 2022 07:37 PM
I am new to Excel and I am learning pivot tables for the first time! I google searched how to create a pie chart from my grand total in a pivot table out of curiosity and I got even more confused about what to do. Maybe Excel has changed since this post was active but I couldn't figure it out.
Eventually, I realized that I could just copy the grand total row and then just paste it below the pivot table and create a pie chart out of that! So if anyone is looking for this solution then I hope this helps!