Monthly Archives: September 2012

Creating a progress bar using MS Excel charts – part 2

The idea behind this post is to offer more examples of MS Excel Chart-based progress bars. To be honest, the possibilities are unlimited—especially if you combine a bit of mathematics with your Excel skills. I designed this (see below) progress bar using a bit of co-ordinate geometry [the co-ordinates of a point at a distance ‘r’ from the centre of a circle is given by X = r cos(theta) and Y= r sin(theta), where theta is the degree in radians. And, just in case, if you are wondering about converting degree into radians in Excel—it is very easy, use the RADIANS formula]. I used a scatter plot chart with two series. Values in the first series are fixed (gray dots)—so they form a circle. Values in the second series (yellow dots), change as the code loops. The numeric value in the center is a WordArt.

ms excel chart based progress bar for definite loop

In all the progress bars till now, I have focused around building them for macros that run/loop for a defined/known number of times. Continue reading