Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.

A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc.

We are going to use a Column Chart and customize it to make it look like a thermometer.

In this example I show you how easy it is to insert a Thermometer Chart using Excel.

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Given your data, ensure that you have the Percentage computed.

Thermometer Chart 01

We have the Percentage computed as the Total divided by the Goal Amount.

Thermometer Chart 02

 

STEP 2: Select the Percentage value, and select Insert > Column Charts > 2-D Clustered Column

Thermometer Chart 04

 

STEP 3: Right-click on the Header and Click Delete.

Thermometer Chart 05

 

STEP 4: Right-click on the bottom column name  and Click Delete

Thermometer Chart 06

 

STEP 5: Right click on the Column itself, and Select Format Data Series.

Thermometer Chart 07

Set the Gap Width to 0%. This will ensure the column fills our entire chart.

Thermometer Chart 08

 

STEP 6: Right click on the Column percentages, and Select Format Axis.

Thermometer Chart 09

Set the Maximum to 1. This will ensure our range is from 0% to 100%.

Thermometer Chart 10

 

STEP 7: Resize the chart to a smaller size. You now have your Thermometer Chart ready.

Update your data values and see the chart go up and down!

Thermometer Chart 11

Thermometer Chart

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below:You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10.W...
Combine Column & Line Charts in Excel Some times you may come across a situation where you want to show 2 variables in one Excel chart.For example, you may have some sales data and a transactional count that you want to show in one chart to see if there is any relationship between the two variables.Well you c...
Bubble Chart: 3 Variables On A Chart A Bubble Chart is an extension of the XY Scatter Chart.  It adds a 3rd variable to each point in the XY Scatter Chart.For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of...
Overlap Graphs in Excel Overlapping graphs in Excel is used to compare two sets of data in one graph, like Actual v Plan results.This overlay of graphs may seem like a difficult exercise but it is a very easy process.First you need to edit your "Plan" graph by clicking on its series and pres...