As we are already acquainted ourselves with the charts which are one of the very important part of data analysis.
The one we are going to discuss now is very interesting a fabulous chart type but not directly available in the Excel.
If want to know how to create the basic charts. CLICK HERE.
A PROGRESS CHART is horizontally placed and used to show the progress.
There is no direct provision in MICROSOFT EXCEL for creating a chart which will show the progress.
So here, we’ll try to create a PROGRESS CHART in EXCEL.
This kind of chart is useful for certain conditions where we want to express the progress of any task visually.
In this article, we’ll learn step by step process of creating a PROGRESS CHART .
Although , anybody can create a progress or thermometer chart , but it would be easier if we have a basic knowledge about the process of creating a simple chart first. CLICK HERE to have a look at the simple chart making process.
A chart which shows the progress of any task is known as a PROGRESS BAR CHART or simply the PROGRESS CHART.
Suppose there are 1000 people who need to take a survey. Till now, only 100 have taken it.
So, if we want to tell the progress, it’ll be best shown by a progress chart.
You must be aware of a progress chart or progress bar . Whenever a heavy application loads, it shows a progress bar, which shows the current status and the final level up to which it has to go, is a progress bar.
The normal charts doesn’t show the highest possible value but only the current value, that’s why we need to use this trick to get it done.
We’ll start creating a progress chart.
Here is the plan to create a progress chart.
Let us first understand the case.
We have a city and there are 1000 voters. We want to create a progress chart for the current number of people who have cast their vote.
Here is the data. We have found out the percentage of voting done using the formula. VOTING LEFT IS NOT USED IN THIS METHOD FOR CALCULATION.
|VOTING IN CITY A|
Above picture shows the chart selected.
After creating the bar. we need to make it look like empty which we can do by selecting it from the styles.
When we create the bar, it’ll be a filled one i.e. filled with a solid color.
Now the bar which was stuck at 100% has been replaced by our new empty bar.
The next step is to delete all the extras from the chart.
Right now we have a chart with a 50% solid bar and a 100% empty bar. Now we’ll get rid of
all the extras available with us like chart title, axes etc. which are not needed. but before that we need to fix the axis’s highest and lowest value.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE