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.