Learn how to use Pivot Charts and Tables to create a dynamic and modern Excel Dashboard
In this video we are creating a dynamic Excel Dashboards from the ground up by using only Pivot Charts and Pivot Tables. This way, the dashboard becomes entirely dynamic, meaning that once new data is added, all the users needs is to click on Refresh and everything gets updated!
As always, we'll be using best practices and main principles, so that the Dashboard is easy to understand and to work with.
The following visualization instruments are going to be used:
-
Actual vs. Budget Bar Charts
-
Progress Charts
-
Pivot Charts
-
Slicers
All with dynamic conditional formatting.
You are welcome to follow along! No Macros/VBA or Add-Ins are going to be needed, just Microsoft Excel 2010 or newer.
We're happy to provide the file used in the video above for free. To see the download link, just fill the subscription form below. This way you'll also be up to date with all our updates!
If you found this video useful, make sure to like it, share it and subscribe to our YouTube Channel! There, you'll find more free video tutorials.
Also, make sure to check out our Excel add-in Pine BI, which allows users to create advanced charts in seconds and help create dynamic Dashboards.
You can also review our Premium Templates, which are already set up and ready to use - all you need to do is just add your data!
Dashboard Tutorials
Chart Tutorials
Check out our Premium Templates
