How to Show Data in a Thermometer Chart in Your Excel Worksheet

When you need to show the data and information in a more intuitive way, you will certainly use a chart. In this article, we will show you how to create a thermometer chart in your worksheet.

The shape of a thermometer is very special. And you can use it to show some special information. For example, you can show the completion of sales volume in the chart. The image below shows the sales target and the completion of a product.Example

Now we will create a thermometer chart for this range.

Create a Thermometer Chart

  1. Click a cell within the range. You can also select the whole range.
  2. And then click the tab “Insert” in the ribbon.
  3. After that, click the button “Column” in the toolbar.
  4. Next choose the option “Clustered Chart” in the drop-down list.Insert Chart
  5. Thus, you will see the column chart in the worksheet. You will also see the “Chart Tools” tab in the ribbon. Here click the button “Switch Row/Column” in the toolbar.Switch Row/Column
  6. In this step, delete the horizontal axis, the gridlines and the legend.
  7. And then right click the column for the target in the chart.
  8. In the pop-up menu, choose the option “Format Data Series”.Format Data Series
  9. In the window, choose the option “Secondary Axis”.Series Options
  10. Click the tab “Fill” in the window.
  11. Set the option into “No fill”.
  12. Next click the “Border Color” tab in the window.
  13. And then choose the “Solid line”.
  14. In this step, set the color for the border.Border
  15. And then click the first vertical axis in the chart.
  16. Set the “Maximum” into “Fixed”. You need to input the number according to your actual worksheet.
  17. Repeat the above step and change the second vertical axis.Axis Options
  18. Now you can close the window.
  19. And then delete the second vertical axis.
  20. Adjust the width of the chart to a suitable size. You can refer to the image below.Adjust Size
  21. After that , double click the first vertical axis again.
  22. And then change the “Major tick mark type” into “Inside”.Inside
  23. Next click the column in the chart.
  24. In the window, set the “Gap Width” into “No Gap”.No Gap
  25. Click the column again and press the right arrow button on the key board to select another column.
  26. In this step, also change the “Gap Width” into “No Gap”.
  27. And then set the fill color for this column in the window. You can choose a suitable color.Fill
  28. In the end, close the window. The major part of the thermometer chart has appeared in the worksheet.
  29. Click the tab “Insert” in the ribbon.
  30. And then click the button “Shapes”.
  31. After that, in the drop-down menu, choose the “Oval”.Insert Shape
  32. Press the button “Shift” on the keyboard and draw a circle in the chart. When you finish drawing a circle, you can release the key and your mouse.
  33. Next change the color of the circle. And move it under the column. Therefore, you have finished the task.Thermometer Chart

You can also make other settings according to your own need. Whenever the number changes in the original range, the thermometer chart will also change accordingly. This works like a real thermometer in your worksheet.

Reject Unknown Source Files

Sometimes you will receive some unknown source files. At this moment, you need to reject them. Some of the files may contain virus or other malicious program. However, if you still get affected by those files, you need to take additional actions, especially for your Excel files. In order to repair corrupt Excel xls data quickly and easily, you can purchase a third-party tool. With this tool at hand, you will never need to worry about your data and information.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair corrupt docx file and outlook repair software products. For more information visit

Comments are closed.