Right-click on the vertical axis on the left and select format axis. Note that there are two vertical axes (left and right), with different values.This will make both the bars align with each other. In the Format Data Series task pane (or dialog box if you are using Excel 2010 or 2007), select Secondary Axis in Series Options.Right-click on the second column (orange column in this example) and select format data series.This will give you the resulting chart as shown below. With the chart selected, click the Design tab.This would insert a Cluster chart with 2 bars (as shown below).

In the drop-down, click the ‘2D Clustered Column’ chart.

In the Charts group, click on the ‘Insert Column or Bar chart’ icon.

Here are the steps to create a thermometer chart in Excel: Note that the Target percentage would always be 100%. In the above data, the Achieved% is calculated using the Total and Target values (Total/Target). Suppose you have the data as shown below for which you want to create a chart to show the actual value as well as where it stands as compared with the target value. In this tutorial, I will show you the exact steps you need to follow to create a thermometer chart in Excel.Ĭlick here to download the example file and follow along. Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value.Ī few scenarios when where it can be used is when analyzing sales performance of regions or sales rep, or employee satisfaction ratings vs the target value. Watch Video – Creating Thermometer Chart in Excel

Bbt chart celsius excel download