- In short
- A value with a segmented target bar. 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 progress toward a target on a segmented bar.
When to use it
It earns its place whenever you have to tracking progress toward a sales target on a segmented bar.
Example scenarios
- Tracking progress toward a sales target on a segmented bar.
- Managers: shows progress toward a target on a segmented bar.
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 Segmented 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
Segmented 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 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 restyle the result by hand?
- Yes. The visual is built from plain Excel objects; recolor, resize and rewrite it as you like.
- 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
- To keep working on the result, use Create Dashboard
- As an alternative, use Mini Columns
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.