Progress Bar Chart

Here is one of the charts how to make date to look more interesting. With kind of chart we can show the progress of sales in different branches or any other progress between several competitors.

At the beginning let’s have simple table with 7 columns. In the first column should be names of the variables you want to compare. In the second column should target for every variable. In the third column are fulfillment to date. In the fourth column is progress. So basically in cell E4 is C4 divided by B4. In the fifth column is length of the progress bar (blue bar). As you can see it is one percent less than the progress as i chose to have slider 2 percents of the whole progress and it is fill by brown color. So that’s what it shows in the F. And finally in the column G is length of the whole progress bar.

Continue reading “Progress Bar Chart”