Tag Archives: ms excel progress bar

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

Creating a progress bar using MS Excel charts

While writing complex VBA programs, or programs that take a lot of time to run (e.g. calculating country/region-wise sales from third-party data), it is useful to give the end-user some sense of the task completed/remaining. I am essentially talking about the progress bar that we see in most software, websites and operating systems. Excel does not have a built-in progress bar that one can use for programming purposes. However, there are several ways of creating one. In this post I am going to use an Excel chart to create such a progress bar–please note that this is not the only way or the best way of creating a progress bar, but definitely one of the easy and effective ways. The end product will look like the one shown in the GIF image below:

ms excel chart based process bar

The first step is to create a 2-D bar chart using data for two series (lets say, Total and Current): Continue reading