What it shows
Compares two values side by side with a compare bar.
When to use it
It tends to help in cases like comparing this year and last year for the same metric on one card. It is aimed mainly at managers, analysts, dashboard authors.
Example scenarios
- Comparing this year and last year for the same metric on one card.
- Managers: compares two values side by side with a compare 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
Dual Comparison 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
- 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).
- Does it update when the source data changes?
- Yes. It redraws automatically whenever the cells you linked change.
Your data is processed on your own computer. Your Excel contents are never shared with AI services.