- In short
- A gauge with a value and a target marker. 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
Shows a value against a target on a half gauge.
When to use it
It earns its place whenever you have to showing monthly target attainment on a half gauge.
Example scenarios
- Showing monthly target attainment on a half gauge.
- Managers: shows a value against a target on a half gauge.
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 Gauge Target 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
Gauge Target does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. Undo Last reverses it whenever you need.
How it differs from similar tools
Instead of hand-building a card, you get a ready layout wired to your cells; the card tracks the data and its look stays fully adjustable.
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
- 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 anything written into my data?
- No. The source cells are read only; the single addition is the visual.
- Can I move to a different template?
- Yes; open the gallery again and build a new template on the same data. The old visual stays until you remove it.
Works well with
- As a complement, use KPI Cards
- Afterwards, try Create Dashboard
- As an alternative, use Mini Columns Below Value
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.