This video shows you how to create a progress bar for actual vs target percentage calculations in Excel.  Excel’s conditional formatting options include something called data bars.  Data bars are normally used to compare values in a single column, so, for example, the smallest value has the smallest bar and the largest value the largest bar.

Here we want to do something a little bit different.  We are not comparing values with each other, we are instead wanting to show the percentage progress of each individual item, actual vs target. The range of values that the data bar has to show is 0 to 1 or 0% to 100%.  The video will show you how to achieve this.

Items that have achieved or exceeded the target are shown in a different colour, but this is not achieved with a data bars rule but instead with a greater than or equal to 1 rule.  You can download the featured file here.

Posted by Chester Tugwell