Class Exam Grade Excel Chart Using Slicers and a Pivot Table

Here is Don’s amazing reply to the recent Friday challenge.

Learn Excel Dashboard Course

In this example, Don has elevated his Excel Slicer Pivot Charting to a whole new level.  Way to go Don!

image

Don created a highly dynamic dashboard allowing users to create their own Grade count by Class and Exam using a Pivot Table, Slicers and a Pivot Chart.

 





You can see a quick demonstration here:

You can download the sample file here:

Learn Excel Dashboard Course

Dons-Challenge-which-chart-is-suitable-pivot-table.xlsx

 



Don gives a lot of credit to his slicer capabilities to this blog:

http://datapigtechnologies.com/blog/index.php/getting-fancy-with-your-excel-slicers/

Data Pig is a great blog on Excel and you should check it out.

Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

 

Thanks again Don!





Steve=True





Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

LEAVE A REPLY

Please enter your comment!
Please enter your name here