What is a thermometer chart: How to create it chart in Excel

What is a thermometer chart?

A thermometer chart is a visualization technique that is used to show a single parameter against the predefined target. This chart looks like a thermometer due to this it is called a thermometer chart. The filled part goes up as the achievement increase. It shows the percentage of achievement done. It is not an in-built chart in excel though we will create it by column chart.

How to create a thermometer chart in Excel

To create a thermometer chart in excel we first need to arrange our data in a particular format as motioned in the below image.

What is a thermometer chart?
What is a thermometer chart

Now after selecting our data we will go to Insert Tab InsertContinue Reading