Can I edit the resulting visual?

Yes. It is made of ordinary Excel objects, so colors, text and size are all freely adjustable.

What happens when I update the cells?

The visual watches the cells it is bound to; change the values and the view redraws itself.

Is anything written into my data?

No. The source cells are read only; the single addition is the visual.

Can I try another look on the same data?

Yes. Just reopen the gallery and pick a different template; the earlier visual remains on the sheet.

Create a Thermometer Chart in Excel

In short: A value filling a thermometer. You pick the template from the gallery and map its fields to your cells; the visual stays bound to the data, updates when it changes, and remains freely editable. The source table is untouched.

What it shows

Shows a value as a filling thermometer, presenting progress toward a goal intuitively.

When to use it

It earns its place whenever you have to showing how close a fundraising or sales goal is.

Example scenarios

Showing how close a fundraising or sales goal is.
Analysts: shows a value as a filling thermometer, presenting progress toward a goal intuitively.

What it needs

One column with the numeric values to compare. You can optionally add the minimum values, the maximum values and the target values.

How to use it

Select the data range or table you want to visualize.
Open the Charts (Visualizations menu) gallery from the XLMind Plus tab.
Pick the Thermometer template and map its fields to your cells.
The visual is inserted bound to your data; it refreshes as the cells change.

What it produces

A live SVG chart shape (auto-refresh and edit).

Effect on your data and undo

Thermometer does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. One click on Undo Last brings everything back.

How it differs from similar tools

It builds a view Excel does not offer natively, as a data-bound, editable visual in one step; the look refreshes when the data changes.

Good to know

Bindings must match the chart's expected shape; auto-refreshes on source change. Requires the listed data fields (value (Cell)).

Limitations

Requires the listed data fields (value (Cell)).

Frequently asked questions

Can I edit the resulting visual?: Yes. It is made of ordinary Excel objects, so colors, text and size are all freely adjustable.
What happens when I update the cells?: The visual watches the cells it is bound to; change the values and the view redraws itself.
Is anything written into my data?: No. The source cells are read only; the single addition is the visual.
Can I try another look on the same data?: Yes. Just reopen the gallery and pick a different template; the earlier visual remains on the sheet.

Works well with

For a similar but different need, use Variable Width Column
As a next step, use Create Dashboard
Often used alongside this tool: KPI Cards

Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.