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