Excel does not have a dedicated Thermometer Chart type in Microsoft 365 for Windows. You can make the familiar thermometer-style progress display with a stacked column chart, using one series for the completed amount and another for the unfilled portion.
Is a thermometer chart built into Excel?
No—not as a named chart type alongside options such as Column, Line, Pie, and Bar. Excel’s chart gallery does not include a ready-made thermometer chart. The term describes a visual design: a vertical container that fills from the bottom to show progress toward a set maximum or goal.
That distinction matters when searching Excel’s Insert tab. You will not find a button called Thermometer Chart, and choosing a chart template online is not the same as selecting a native chart type. A template may contain a chart already configured for you, while a custom chart is assembled from ordinary Excel features.
For a basic thermometer, a stacked column chart is usually the simplest approach. One colored series represents the current value; a second, neutral-colored series represents what remains to reach the maximum. The two series stack into a single column whose full height represents the scale. Shapes can be added to suggest a round bulb, but that decoration is separate from the data chart.
How the chart works
A thermometer chart is useful when a number has a clear lower and upper bound, such as 68% of a project completed, 420 units produced out of a 600-unit target, or 7 of 10 training modules finished. The chart’s vertical axis supplies the scale, and the filled portion shows the value against that scale.
For a percentage, the two chart values should add to 100%. If completion is 68%, the remaining portion is 32%. A stacked column then has a total height of 100%, with the completed part at the bottom. For a count with a goal of 600, use the actual count and the difference between the goal and the count: 420 and 180.
The chart depends on choosing an appropriate maximum. If the value is 68% but the axis ends at 80%, the bar will look nearly full even though the intended scale is 100%. Conversely, if a 420-unit value is plotted on an axis ending at 1,000 instead of its 600-unit goal, it will look less complete than it is relative to that goal. Use a consistent scale that matches the question the chart is meant to answer.
Build a basic thermometer chart
This example assumes completion is stored as a percentage, with 100% as the maximum. In A1:C2, enter the following layout:
- A1: Measure; B1: Complete; C1: Remaining
- A2: Project; B2: 68%
- With the completion value in B2, enter
=1-B2in C2. The result is 32%.
Select A1:C2, then choose Insert > Insert Column or Bar Chart > 2-D Stacked Column. Excel should create one category, Project, with Complete and Remaining as the two stacked series. If it instead displays two categories or the wrong orientation, use Chart Design > Switch Row/Column.
Set the vertical axis to the intended scale. Right-click the vertical axis and choose Format Axis. In Axis Options, set the minimum bound to 0 and the maximum bound to 1 for a percentage chart. Excel stores 100% as 1, so a maximum of 1 is correct even if the values display with percent signs. You can leave the axis visible to communicate scale, or remove it for a cleaner graphic if the value is also displayed elsewhere.
To make the chart resemble a thermometer, select the Complete series and choose a strong fill color in the Format Data Series pane. Give Remaining a pale gray or other subdued fill. Remove the legend if the meaning is obvious or add a clear label if it is not. Use the Chart Elements button beside the selected chart to remove gridlines, the axis, or the chart title as needed. A text box can show the exact percentage, because a short column alone may not communicate a precise value.
Format it for readability
Thermometer charts are most effective when they are visually simple. The completed series needs strong contrast with the background and with the remaining series. Avoid using two equally vivid colors: the reader should immediately distinguish the filled amount from the unfilled amount. If the chart appears in a report with other colors carrying defined meanings, use those meanings consistently.
To make the column wider, select a series, open Format Data Series, and reduce the Gap Width setting. A lower gap width makes the column wider; a value near zero can make it look like a thick vertical tube. The exact result depends on the chart’s size, so adjust it while viewing the final chart dimensions.
A common embellishment is a circular bulb at the bottom. You can add an oval from Insert > Shapes, format it to match the filled series, and position it over the base of the column. This is a drawn shape, not part of the plotted data. If the chart is resized or the value changes, check the alignment: the oval may need repositioning, and it will not automatically update its size or color based on the cell value.
Keep the visual connected to a readable number. A thermometer with no scale, title, or value label may look polished but leave readers unsure whether it represents a percentage, units, or dollars. A title such as Project completion and a data label such as 68% usually provide enough context without clutter.
Show a goal or target
A thermometer’s maximum and its target are not always the same thing. If 100% means reaching a goal, the maximum is also the goal. But a report might show progress toward a milestone within a larger possible range—for example, 420 units toward a target of 600, even though production could continue beyond 600.
For an absolute target, the chart data can use the actual value and the amount still needed. With actual value in B2 and target in D2, enter =D2-B2 in C2 to calculate the remainder. This assumes the actual value does not exceed the target; if it does, the remainder becomes negative, which does not form the intended positive stacked column. Decide how to represent over-target results rather than allowing the chart to mislead. One option is to cap the displayed completion at the target while showing the true value in a separate label.
If readers need to see a threshold below the maximum—for example, a warning level at 50%—a colored fill alone is not enough. Add a clearly labeled target marker or use a chart design that plots the threshold explicitly. A manually drawn line is quick but can drift when the chart is resized. A data-driven marker takes more setup, particularly with a one-column chart, so document the threshold and test the result after changing the data.
Common problems and fixes
- The bar fills in the wrong direction: Confirm that the actual series is first and Remaining is second in the stacked column. Use Chart Design > Select Data to review or reorder the series.
- The bar looks full too early: Check the vertical axis maximum. For a percentage stored as 68%, use a maximum of 1, not 100; for a 420-unit value, set the maximum to the intended unit scale, such as 600.
- The remainder is negative: The actual value is above the target. A conventional stacked thermometer is designed for nonnegative parts, so choose an over-target display or adjust the chart logic rather than plotting a negative remainder.
- The chart shows a legend or labels that add clutter: Remove unnecessary elements, but retain enough context for a reader to identify the measure and scale. A nearby cell or text label can show the exact value.
- The bulb no longer lines up: The oval is a floating drawing object, not a chart series. Reposition it after resizing, or omit the bulb for a more robust chart that is easier to maintain.
Also check the source values. A percentage entered as 68 rather than 68% is numerically 68, not 0.68, and will not behave as expected on a 0-to-1 axis. Format the cell as Percentage or enter the decimal as 0.68. Make sure the chart and its labels use the same units.
When to use another chart
A thermometer is a single-value progress display, not a universal chart for temperature data. If you want to show temperatures across dates or times, a line chart is usually more informative because it shows change and patterns over time. For comparing completion across several projects, a horizontal bar chart or several small progress bars may be easier to compare than a row of narrow thermometers.
For a dashboard where space is tight, a percentage cell with a data bar may be enough. Excel’s Conditional Formatting data bars show relative cell values directly in a worksheet, without a separate chart object. They are convenient for tables, though their scale and appearance differ from a thermometer and should be configured carefully when comparing values.
A thermometer graphic is a good choice when there is one prominent measure, a meaningful fixed maximum, and a need for a quick visual impression. Use a table, line chart, or bar chart when readers need exact comparisons, historical movement, multiple categories, or more than one target.
Frequently Asked Questions
Can I create a thermometer chart in Excel without an add-in?
Yes. A stacked column chart, suitable source values, and ordinary formatting options are enough for a basic version. An add-in is not required.
Can the thermometer chart update when the cell value changes?
Yes. If its series values refer to worksheet cells, the filled portion updates when those cells change. Decorative shapes, such as an added oval bulb, may need manual adjustment.
Why does my thermometer chart show 6800%?
This often happens when 68 is formatted as a percentage. Excel interprets 68 as 6,800%. Enter 68% or 0.68 for a value of 68 percent.
Can Excel make a thermometer chart from temperature readings?
You can make a thermometer-style display for one reading, but it is usually not the best way to show readings over time. A line chart makes trends and changes easier to interpret.
Does the same method work in Excel for Mac or Excel for the web?
The underlying stacked-column approach is similar, but ribbon layouts and formatting controls can differ. Excel for Mac has chart formatting tools, while some chart editing options may be less available or arranged differently in Excel for the web. If a named command is not visible, look for the chart’s contextual Design and Format controls.
Related
- Excel Conditional Formatting Number Formats Explained
- Excel Conditional Formatting With Dates: A Practical Guide
- Excel Conditional Formatting for Date Ranges Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Pivot Table Filter Not Refreshing? Fixes That WorkIf an Excel pivot table filter is not refreshing, first select the PivotTable and choose PivotTable Analyze >…
- Waterfall Chart in Excel: Sample Data and StepsTo make a waterfall chart in Excel for Microsoft 365 on Windows, enter categories in one column and…
- Excel Pivot Chart Slicers: How to Add and Use ThemAn Excel PivotChart slicer is a set of clickable filter buttons for a PivotTable and its connected PivotChart.…
- Excel Clustered Column Chart Bar Width: How to Adjust ItIn Excel for Microsoft 365 on Windows, change the width of columns in a clustered column chart by…
- Excel Dashboard Color Schemes That Make Data ClearAn effective Excel dashboard color scheme uses a small, consistent palette: neutral backgrounds, one or two colors for…
- How to Build a KPI Dashboard in ExcelTo build a KPI dashboard in Excel, put clean, consistently defined measures in a structured data table, calculate…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.