Progress Bar Chart

Would you like to show progress on a KPI by putting a nice progress bar into your report? In this tutorial I’ll show you a very easy way of making a progress bar chart.

progress bar chartThis chart too is a version of a thermometer chart with two single value data series. It is basically same chart as self filling chart. Only this is a bar chart instead of a column chart. Idea is basic, while one series is static, other will be dynamic, changing as we input data. By adding a label with percentage, we will have a progress bar chart.

We will need a setting like below for this chart.

 

We need a total cell that gets the sum of values from a list. And a cell that will contain a target value for comparison. When this part is done we need a simple addition for percentage part.

total% is equal to total/target (formatted as percentage), target% is equal to 1 (formatted as percentage).

Now select total% cells and insert a bar chart. Then select the chart and access “select chart data” from right-click menu. Here add a series (select target% for name and 100% as value). At this point you will have a bar chart with two data series.

 

Click on the total series and format it:

  • fill: solid(blue)
  • add white and bold label (inside end)

Click on the target series and format it:

  • fill: no fill
  • border: thick blue)
  • Set series overlap to 100%.

Now you established progress bar chart. Remove any legend, axis, etc. and you are done.

Progress Bar Chart 1

Bonus:

loading_bar_chart (5)

You can make a little more formatting  and get another loading bar chart version from this chart. All you need to do is; make a copy of this chart and

  • Set total% series to secondary axis (if you can’t select, set series overlap to 50%, but correct it when you finished).
  • Set fill to “no fill”.
  • Set border to black thick border
  • Set label font color to black.

Set target% series fill color as shown in the picture

 

Now you have a nice 5th loading bar chart alternative.

If you like, you can download the example workbook and check the charts for practice.

You may also like...

2 Responses

  1. Verena says:

    It’s not my first time to go to see this website, i am visiting this
    website dailly and get good data from here everyday.

  1. February 29, 2016

    […] Progress Bar Chart: This is a simple chart that fills with added data while displaying a percentage of achievement against a target. Very useful for visualizing progress. […]

Leave a Reply

Your email address will not be published. Required fields are marked *