XLMind Plus · KPI Cards

Gauge Target

A gauge with a value and a target marker.

What it shows

Shows a value against a target on a half gauge.

When to use it

It is most useful when showing monthly target attainment on a half gauge. It is aimed mainly at managers, analysts, dashboard authors.

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

  1. Pick template
  2. Bind cells
  3. Style
  4. Insert

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. 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

Does it update when the source data changes?
Yes. It redraws automatically whenever the cells you linked change.
Does Gauge Target change my source data?
No. Gauge Target leaves your source data untouched and adds the result as a separate item.
Does it work offline?
Yes. Gauge Target runs without an internet connection; going online is only needed for licensing, payment and updates.

Your data is processed on your own computer. Your Excel contents are never shared with AI services.