How to Create Debt Thermometer in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to create a debt thermometer chart in Excel. A debt thermometer chart is very useful when you want to represent work progress or the percentage of a fraction of work. If you have a certain target and you want to show or record a tract how much the work is done, in this case, a debt thermometer chart is the best way to represent it. It not only helps to track the record of your work but also gives you direction on where you are having problems and where you need to change your line of work. So, it is essential to learn how to create a debt thermometer chart in Excel.


How to Create Debt Thermometer in Excel ((With Easy Steps))

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to create a debt thermometer chart in Excel on your own. The steps are described as follows.


Step 1: Creating a Dataset to Create Debt Thermometer Excel

In this case, we aim to create a debt thermometer chart in Excel using a proper dataset. For instance, we have Month in column B and Sales in column C. At the very beginning, we have to determine the total sales and percentage of it by using this dataset.

Dataset to Create Debt Thermometer in Excel

  • Then, insert the following SUM function in the C11 cell.
=SUM(C5:C10)

Insert Formula to Create Debt Thermometer in Excel

  • After that, you will get the result by using the SUM function.

Result to Create Debt Thermometer in Excel

  • Moreover, insert the following SUM function in the C12 cell.
=C11/C12

Insert Formula to Create Debt Thermometer in Excel

  • Finally, you will get the result using the division.

Result to Create Debt Thermometer in Excel

Hence, your dataset is ready to use for inserting a chart with its help.


Step 2: Inserting 2-D Column Chart

Now, our goal is to create a debt thermometer chart in Excel by inserting a 2-D column chart. A 2-D column chart is mainly used to represent certain data within the proper visual range. The steps of this process are below.

  • First, select the table >> Insert >> Chart >> 2-D Column options.

Insert 2-D column Chart to Create Debt Thermometer in Excel

  • Then, you will get the chart accordingly.

Chart to Create Debt Thermometer in Excel

  • Afterward, click on the chart and you will see a Chart Design option in the Menu Bar. Then in the Chart Design option, click on the Switch Row/Column options.

Chart Design to Create Debt Thermometer in Excel

  • Moreover, you will get the final chart according to your wish.

Result to Create Debt Thermometer in Excel

Therefore, we have got the chart accordingly but now we want to format it for better representation.


Step 3: Formatting the Chart

Furthermore, we want to create a debt thermometer chart in Excel by formatting the chart. We can achieve this goal by following the below steps.

  • To begin with, click on the chart and right-click on the chart to select the Format Data Series feature.

Format Series to Create Debt Thermometer in Excel

  • In addition, in the Format Data Series window, select the Secondary Axis option.

Secondary Axis Selection to Create Debt Thermometer in Excel

  • Furthermore, you will get a chart similar to the below image.

Chart to Create Debt Thermometer in Excel

  • Therefore, right-click on the axis of the chart and select the Format Axis option.

Format Axis to Create Debt Thermometer in Excel

  • After that, in the Format Axis window, choose the Maximum and Minimum options.

Maximum and Minimum to Create Debt Thermometer in Excel

  • Therefore, you will get a chart with min to max range percentage. Then, select the chart again and right-click on the chart, and choose the Format Data Series option.

  • Subsequently, in the Format Data Series window, select No Fill in the Fill portion, choose Solid line in the Border portion, and select the color as you wish.

  • Finally, you will get the chart like the below image.

  • Next, right-click on the title options and select the Format Axis option.

  • Hence, in the Format Axis window, select the Inside option in the Major type.

  • Now, you will get the final result as below.

So, we have got the first of the chart to create a debt thermometer in Excel.


Step 4: Showing Final Result to Create Debt Thermometer Excel

Finally, we can create a debt thermometer chart in Excel by the following steps.

  • First, go to Insert >> Shapes options.

  • Secondly, you will get the circle shape accordingly.

  • Thirdly, select the new shape, then right-click on it, and select the Format Shape option.

  • Fourthly, in the Format Shape window, select the No line option.

  • Lastly, you will get the final result.


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Henceforth, follow the above-described methods. Hopefully, these methods will help you to learn how to create a debt thermometer chart in Excel. We will be glad to know if you can execute the task in any other way.  Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our best to solve the problem or work with your suggestions.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo