Create advanced Excel Charts in a single click with Pine BI

Pine BI is a premium Excel Add-In, which allows users to create advanced charts in a single click and to turn a standard workbook into a modern Dashboard.

Powerful. Dynamic. Beautiful.

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.

The file used in the video above is available for free download. Just click on the button below:

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

Create Amazing Excel Dashboards with Pine BI

Pine BI is a premium Excel Add-In, which allows users to create advanced charts in a single click and to turn a standard workbook into a modern Dashboard.

Powerful. Dynamic. Beautiful.

Check out our Premium Templates

Copyright © 2018 - 2020 PINEXL Ltd.