top of page
Create an Excel Speedometer with Pine BI
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.

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!

Subscribe to download file

Click here to download

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
Header 1.1.PNG

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

bottom of page