XLMind Plus · Charts

Status Spectrum

A value on a red to green spectrum.

In short
A value on a red to green spectrum. Select your data, pick the template and map the fields; the result is an editable, data-bound visual that refreshes as your cells change. Nothing in the source is modified.

What it shows

Places a value on a red to green spectrum, conveying status through colour.

When to use it

It earns its place whenever you have to showing a risk or health score on a colour band.

Example scenarios

  • Showing a risk or health score on a colour band.
  • Analysts: places a value on a red to green spectrum, conveying status through colour.

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

  1. Select the data range or table you want to visualize.
  2. Open the Charts (Visualizations menu) gallery from the XLMind Plus tab.
  3. Pick the Status Spectrum template and map its fields to your cells.
  4. 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

Status Spectrum does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. Undo Last rolls the change back in a single step.

How it differs from similar tools

It creates this chart type without helper columns, tricks or macros; the result stays bound to your data and remains hand-editable.

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

Is the output locked, or can I change it?
It stays fully editable: every part is a normal Excel element you can move, color and resize.
Is the result live?
Yes. It works off your data, so when the source cells change, so does the visual.
Is my source table modified?
No. The tool only reads your data; the only addition to the sheet is the visual itself.
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

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.