How to create a Thermometer Chart in Excel

A Thermometer chart looks like a  thermometer. The Thermometer chart is a great way to represent data in Microsoft Excel when you have an actual value and a target value and excellent to analyze sales performance.

Does Excel have a Thermometer chart?

The Thermometer chart is not a default chart in Excel or any Office programs; you have to create one from scratch. In this tutorial, we will explain how to create a thermometer chart in Microsoft  Excel.

How to create a Thermometer Chart in Excel

Follow the steps below to create a thermometer chart in Excel.

1. Launch Excel.
2. Enter data into the Excel spreadsheet.
3. Select the achieve and target data
4. Click the Insert tab
5. Click the Column button in the Charts group and select the Stacked column from the drop-down menu.
6. A Chart Design tab will appear; click it.
7. On the Chart Design tab, click the Switch the Row and Column button.
8. Right-click the Orange series and select Format Data Series from the context menu.
9. A Format Data Series pane will appear.
10. Drag the Gap width to zero
11. Click the fill section and click No Fill.
12. Click the Border section and click Solid Line.
13. Then select the color you want from the Color drop-down menu.
14. Under the border section, input 1.5 pt in the Width box.
15. Now resize the chart.
16. Remove the Chart title.
17. Then go to the Format tab and select the Oval shape from the Insert Shapes group.
18. Draw the oval shape at the bottom of the chart.
19. Click the Shape Outline button and select a color that matches the color in your chart.
20. Now, we have a Thermometer chart.

Launch Excel.

Enter data into the Excel spreadsheet.

Select the achieve and target data

Click the Insert tab

Click the Column button in the Charts group and select the Stacked column from the drop-down menu.

A Chart Design tab will appear; click it.

On the Chart Design tab, click the Switch the Row and Column button.

Right-click the Orange series and select Format Data Series from the context menu.

A Format Data Series pane will appear.

Drag the Gap width to zero.

Click the Fill section and click No Fill.

Click the Border section and click Solid Line.

Then select the color you want from the Color drop-down menu.

Under the border section, input 1.5 pt in the Width box.

Now resize the chart.

Remove the Chart title.

Then go to the  Format tab and select the Oval shape from the Insert Shapes group.

Draw the oval shape at the bottom of the chart.

Click the Shape Fill button and select a color that matches the color in your chart.

Now, we have a Thermometer chart.

Read: How to change default browser when opening hyperlinks in Excel.

We hope this tutorial helps you understand how to create a Thermometer Chart in Excel; if you have questions about the tutorial, let us know in the comments.