What it shows
Shows an actual value against a benchmark line on a bullet scale.
When to use it
It tends to help in cases like presenting performance against a reference such as an industry average. It is aimed mainly at managers, analysts, dashboard authors.
Example scenarios
- Presenting performance against a reference such as an industry average.
- Managers: shows an actual value against a benchmark line on a bullet scale.
What it needs
Bound cells or ranges (value, target, comparison, trend as the template needs). Supported data types: cells or ranges (live-bound).
How to use it
- Pick template
- Bind cells
- Style
- Insert
What it produces
A live SVG KPI card (auto-refresh and edit).
Effect on your data and undo
Benchmark 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
Auto-refreshes when a bound cell changes. Honest empty / dash state. Missing source shows a source-not-found state.
Limitations
Binds to one or more live cells.
Frequently asked questions
- Where does the result go?
- A live SVG KPI card (auto-refresh and edit).
- Does it update when the source data changes?
- Yes. It redraws automatically whenever the cells you linked change.
- Does Benchmark change my source data?
- No. Benchmark 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.