What it shows
Places a value on a red to green spectrum, conveying status through colour.
When to use it
It saves time on work such as showing a risk or health score on a colour band. It is aimed mainly at analysts, managers, report authors.
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
- Pick chart type
- Bind data
- Adjust settings and design
- Insert
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. You can reverse it at any time with Undo Last.
How it differs from similar tools
Unlike a static picture you paste in by hand, it stays bound to your data and redraws itself whenever the source cells change.
Good to know
Bindings must match the chart's expected shape; auto-refreshes on source change. Honest empty / dash state. Invalid data shows a localized validation message (no wrong chart).
Limitations
Requires the listed data fields (value (Cell)).
Frequently asked questions
- Where does the result go?
- A live SVG chart shape (auto-refresh and edit).
- Does it update when the source data changes?
- Yes. It redraws automatically whenever the cells you linked change.
- Does Status Spectrum change my source data?
- No. Status Spectrum leaves your source data untouched and adds the result as a separate item.
Your data is processed on your own computer. Your Excel contents are never shared with AI services.