In this post, you will get to know about the Thermometer Chart in Microsoft Excel. Also, you will learn to create a Thermometer Chart in the Excel worksheet.
What is Thermometer Chart?
A thermometer Chart in Microsoft Excel is to track a particular task. Also, it displays the current status of that task. It helps to achieve the target of that task. A thermometer chart is also called a Temperature chart.
How to Create a Thermometer Chart in Excel?
- To get started, select the data series to add the thermometer chart.
- Go to the Insert Tab, click the Column Chart icon and select the 2-D Column Chart.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-132345-1024x584.png)
- Now, go to Design Tab and select the Switch Row Column option from the Data group.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-134129-1024x580.png)
- Now, right-click on the Target series in the chart and select the Format Data Series option.
- Select the plot series on Secondary Axis as in the below image.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-135111-1024x584.png)
- Now, select the Vertical (Value) Axis in the chart and right-click on it.
- Select the Format Axis option and switch the Maximum Bound to 1 and Minimum Bound to 0 as in the below image.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-141021-1024x585.png)
Remove the Secondary Vertical (Value)Axis by clicking on it and pressing the delete key. Also, remove the Chart Title by clicking on it and pressing the delete key.
- Click the visible column on the chart and select the Format Data Series option.
- Go to the Fill & Line tab in the navigation pane, then select the No Fill option from Fill and the Solid Line option from Border.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-141446-1024x585.png)
- Now, right-click on the Vertical Axis and select the Format Data Series option.
- On the navigation pane, select the Major Type as Inside in the Tick Marks segment.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-142054-1024x582.png)
- To make it more interesting pick an oval shape from the Shapes menu in the Insert Tab.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-142554-1-1024x579.png)
- Insert an oval shape under the column so that it appears like a thermometer. Select the No Line option from the Format Shape pane.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-143726-1024x582.png)
The below image shows the final look of the created Thermometer Chart.
![How to Create a Thermometer Chart in Excel?](https://developerpublish.com/wp-content/uploads/2021/03/Screenshot-2021-03-31-131544-1-1024x584.png)