XLMind Plus · KPI Cards

Segmented Target

A value with a segmented target bar.

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

  1. Select the data range or table you want to visualize.
  2. Open the KPI Cards (Visualizations menu) gallery from the XLMind Plus tab.
  3. Pick the Segmented Target template and map its fields to your cells.
  4. 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

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.