- In short
- A value compared to a benchmark. 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 an actual value against a benchmark line on a bullet scale.
When to use it
Most useful when you need to presenting performance against a reference such as an industry average.
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
- Select the data range or table you want to visualize.
- Open the KPI Cards (Visualizations menu) gallery from the XLMind Plus tab.
- Pick the Benchmark 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 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. Undo Last rolls the change back in a single step.
How it differs from similar tools
The card is bound to your cells: change the value and the card refreshes, and it stays freely editable as a shape. No formulas or macros to maintain.
Good to know
Auto-refreshes when a bound cell changes. Binds to one or more live cells.
Limitations
Binds to one or more live cells.
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.
- Does it refresh when the data changes?
- Yes. The visual is bound to your cells and updates as the linked values change.
- Will my table change?
- No. Your data stays exactly as it is; only the visual is added to the sheet.
- 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
- A good companion is KPI Cards
- To keep working on the result, use Create Dashboard
- As an alternative, use Segmented Target
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.