- In short
- A big value with a mini column chart below it. Select your data, pick the template and map the fields; the result is an editable, data-bound visual that refreshes as your cells change. Nothing in the source is modified.
What it shows
Shows a big value on top with full width columns (a trend) below.
When to use it
It earns its place whenever you have to presenting a headline metric with a periodic column trend below it.
Example scenarios
- Presenting a headline metric with a periodic column trend below it.
- Managers: shows a big value on top with full width columns (a trend) below.
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 Mini Columns Below Value 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
Mini Columns Below Value does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. If it is not what you wanted, Undo Last restores the previous state.
How it differs from similar tools
Instead of hand-building a card, you get a ready layout wired to your cells; the card tracks the data and its look stays fully adjustable.
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 edit the resulting visual?
- Yes. It is made of ordinary Excel objects, so colors, text and size are all freely adjustable.
- Does it refresh when the data changes?
- Yes. The visual is bound to your cells and updates as the linked values change.
- Is anything written into my data?
- No. The source cells are read only; the single addition is the visual.
- Can I try another look on the same data?
- Yes. Just reopen the gallery and pick a different template; the earlier visual remains on the sheet.
Works well with
- Often used alongside this tool: KPI Cards
- To keep working on the result, use Create Dashboard
- At the other end of the family sits Dual Comparison
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.