Creating a Thermometer Chart in Excel (EASY STEP BY STEP)

Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value.

A 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.

In this video, I will show you the exact steps you need to follow to create a thermometer chart in Excel.

Note: The thermometer chart is useful when you have one actual value and target value set. In case you have multiple such datasets, you either need to create multiple such thermometer charts, or need to use a different chart type (such as the Bullet chart or the Actual Vs. Target charts).

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[jeanettesefers]

Best tutorial ever! Thank you for making it simple.

[jscjazz]

Thank you for posting this, just saved my bacon for a work project!!!

[shubhampatil]

Thanks team to make it simpler and not giving too much of text like websites 😀

[manonmitchell]

Thank you so much for this! I've wanted to do this for so long and you showed me how to do this so EASILY! WOW! GREAT!

[investingincanada-where]

Thank you for this great video that i used to create the thermometer for my kid's summer reading challenge.

[KatapultCoaching]

Thank you much for the downloaded file!!! Love it!

[traceycarpelibrum]

Brilliant, thank you so much for the tutorial 🙏

[peebee]

Exactly to the point and so perfect! Thank you so very much!!!

[deborahrabine]

This is fantastic! Something I have been wanting to do. Thank you for sharing.

[gladys]

Thank you! This helped me make a great report!

[Razzidog]

So helpful and easy to follow! Thank you for sharing this video!!!

[lizethobando]

Great video. I am glad I found your video. Very informative. Easy to follow. Thank you. Great Job!

[kiran]

Thank you so much. Was really helpful!! :)

[georgemensah]

This is Sweet!!! Thanks for figuring it out. Such a cool hack.

[lifewithmace]

I have exam tomorrow and I guess it will help me :)

[bigpapapage]

that worked out great thank you very much! I will now sub

[supkiotta]

Thank you! Everything I read online was not explaining it correctly. This helped me make a dual thermometer, after all the other headaches.

[ArtamStudio]

Almost replicated in GSheets, but it lacks the "Format Data Series" function (2:10). I can add Right Axis in Series - Format - Axis, but the results are not comparable. Still, clear and concise and gets me going in the right direction, thank you!

[NiagarafallsmuseumsCanada]

This was great - thanks - however, can't figure out how to make it red - can change everything but the achieved axis - blue is nice, but hoping to do it in red (for several reasons)

[deannie]

Is there a way to show what goes over 100%? I'm trying to demonstrate when the temp is high because folks go extra mile and put forth great effort. Thank you for such a great demo!