Have a look at the chart above; fascinating! isn’t it?? (Didn’t like?? Even if you didn’t like it, don’t worry, you’ll make it better . We are teaching how to make any kind of chart as per your imagination )
This is a step by step guide to create a THERMOMETER CHART in Excel. The article contains pictures and infographics to help you understand easily and correctly
Kindly go through the article if you want to learn how to make this chart and ofcourse you can create your own design too.
But before trying to create this chart , you must know the basics of chart creation.
If want to know how to create the basic charts. CLICK HERE.
The procedure of creating thermometer chart is almost like the progress chart which we tried last time.
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 THERMOMETER 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 THERMOMETER 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 THERMOMETER CHART or the PROGRESS CHART.
The progress is mostly expressed as a percentage and it resembles the thermometer which has an upper limit and a value starts reaching the highest value slowly, hence the name , thermometer 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. Similarly to PROGRESS BAR CHART which is horizontal , the THERMOMETER CHART is vertical which can be used to show temperature, precipitation etc. in the beautiful customized chart columns.
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 THERMOMETER chart.
WE’LL CREATE A CHART TO SHOW THE CHANCES OF PRECIPITATION ON A PARTICULAR DAY OF FOUR DIFFERENT CITIES NAMELY 1, 2, 3 AND 4.
Here is the plan to create a THERMOMETER chart.
Let us first understand the case.
We have four cities 1, 2, 3 and 4. The chances of precipitation are given in a table shown below.
Above picture shows the chart selected.
After creating these two columns,
copy one of the column and paste it six more time so that we have eight column in total.
Now choose the colors as per the design and use the fill options as already told so that we have four columns with solid colors and four with just outlines.
The colors chosen for our example are BLUE, GREEN, RED and YELLOW.
The final picture after copying and treating all the figures something like this will be the situation in our
NOTE: The design shown here can be changed as per your choice. You can choose any customized shape to take place of standard columns.
Refer to the picture below.
Double click the vertical axis. Again the options on the right side will open.
Go to the Axis options.
Put the minimum value as 0 and maximum value as 1.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE