Progress Chart With Pivot Table and Slicer

In this video, I'll show you how to create a dynamic progress chart using a pivot table and slicer. This is a really neat way to level up your dashboards with interactive charts.

In this video I will demonstrate:
How to create a pivot table
How to create a doughnut chart
How to use a slicer to filter data

Timestamps
0:00 Intro
0:30 Creating a pivot table
4:00 Creating a doughnut chart
18:45 Creating a slicer to filter the data

If you find my videos informative, please give this video thumbs up. And, please consider subscribing and clicking the notification icon to be notified when I release new videos.

#excelhowto #exceltutorials #learnexcel

[janicelayne]

I love the pace & depth at which you walk us through setting up these progress charts. Thank you so much!

[everwelwisher]

I am really very thankful to you sir, i created my first progress chart step by step with your video

[MerleCox]

Great explination and I appreciate you talking slow enough so I could do it while you were explaining how to do it. Keep up the good work!

[RickySpanish]

Great video! It seems quite complicated but you actually make it easy. Thanks

[ashleyjordan]

What a great video. It is very helpful and you take your time to show each step . How do I download the source data so that I can attempt the process myself?

[ashmc]

Hi! I love this look! How can I show Core Budget with year to date figures and then the deficit in 2 rings of the same doughnut?!

[Retro-RPM]

Good video! I've seen speedometer type progress charts in Excel. I'm assuming they are using doughnut charts like this video - could you do a video on how to create a speedometer chart?

[jamesfoster]

Thank you for the video. Very informative. Quick question. I have values that total 100% but for some reason, I cannot get the % sign to be visible. Anything below 100% will show the % sign. Any suggestions? Thank you.

[jayavish]

Hi. This is a great tutorial. I tried using this for an application I have. It works great when the filter returns all categories. But if one salesperson has no result for one category then the circles shift to the left. Eg if one country sold no hamburger then the doughnut for milkshake displays in the 3rd position and uses the formatting for hamburger rather than milkshake purple. Is there any way for pivot table to always return all categories even if value is 0?

[marissabaird]

What if the progress is over 100%, how do you get to keep the consistent formula with all the others, but make it so the progress chart is full? I have a category that is at 116% and if I keep the same formula it shows up negative.