Create this chart 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 create an Actual vs. Target chart in Excel with dynamic colors

There are many different Actual vs. Target charts, which can be created in Excel. They are very useful for all kinds of reporting, however can get quite complicated fast. This one makes it easy to understand the data straight away by implementing dynamic colors. If the actual value reaches the target, the color of the column changes, thus making it very easy separate between different periods or KPIs.

In the following video you can follow the process of creating such chart.

 

A link to download a chart template for free is available below.

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, where you'll be able to 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!

More Chart Tutorials

Dashboard 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.