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.



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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Area Chart: Highlight Chart Sections When you are showing 12 month sales results using a Line Chart and want to highlight certain values within the chart to make them stand out (like Q2 & Q3 results), then an Area Chart will be needed. To do this there are a few steps to follow: 1. Enter the Line Chart for...
Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...
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...