What it shows
Shows progress toward a target on a segmented bar.
When to use it
It tends to help in cases like tracking progress toward a sales target on a segmented bar. It is aimed mainly at managers, analysts, dashboard authors.
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
- Pick template
- Bind cells
- Style
- Insert
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. 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 work offline?
- Yes. Segmented Target runs without an internet connection; going online is only needed for licensing, payment and updates.
- Can I undo what it does?
- Yes. Undo Last on the ribbon reverses the last action in a single step.
- Where does the result go?
- A live SVG KPI card (auto-refresh and edit).
Your data is processed on your own computer. Your Excel contents are never shared with AI services.