Quick KPI Chart in Excel

Today’s presentation, the Quick KPI Chart will give you lots and lots of help if the phrase key performance indicator is not new to you.

Small, Simple, Smart, Quick are the words that first come to mind when we think about an excel dashboard.

Many people or even excel gurus think it is a complicated workflow to create an excel dashboard. Fortunately, there are situations when we don’t have to struggle for making something spectacular.

We’ll introduce such a little trick in today’s article.

We hope that after you have reached the end of the article and tried the excel template, again take a big step toward getting to know the possibilities of Excel. As you will see, there are no limits!

Quick KPI Chart – In motion

We’ll show you how cool this solution is. Take a closer look at this little animation! Only one number needed to be changed and the chart becomes dynamic.


Quick KPI Chart – How it works?

In the picture below there are three cells (KPI1, KPI2, and KPI3) where the current value can be changed freely.

It is important to note that every single chart containing 10×10 small squares. We have formatted them not to show the grid. The first KPI cell’s value is now set to 25%, let’s see what will happen after this!

To create a quick kpi chart just written in the formula on the left-hand side table checks how can the given number be (25) created for the chart. In this example, the value of the ‘Horizontal Lines’ is 10 so it colors the first line of the mini chart (that is the 10×10 squares) all the way.


KPI Chart Formulas

If we follow the formula, then the E7 cell works in a similar way. It can be seen that by the given amount the value is 10 again, so the second line of the chart is needed to be colored fully. The interesting thing starts at the third column (namely in the E8 cell).

Because the given KPI value is 25 we can’t color the third row of the chart fully because we would cover 30 little squares. The value in the E8 cell is 5, this is how we get the result seen on the picture, and this means that from left to right we will color green 25 little squares/units.

Have you thought that with a help of such simple formula (and choosing the appropriate chart) so quickly we solve this task? To tell you the truth we – the site administrators – were surprised by this solution, although you know we didn’t start to learn Excel yesterday.

The G7 – G10 cells belonging to the KPI2 indicator, to the 48% are generated by a similar principle previously introduced. To display the 48% value we color 48 little squares, so 4×10, and 8 in the fifth row.

You can apply the quick kpi chart in many business situations. Can be created in minutes a mini chart capable of displaying more key performance indicators and with the help of this you can build an excel dashboard. Check our gauge chart and waffle chart section too! OK, do not hesitate to download our latest excel solution!