- In short
- Nested rectangles sized by value. 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 categories as nested rectangles sized by value, conveying share through area.
When to use it
Typical use: comparing the share of budget items or product groups by area.
Example scenarios
- Comparing the share of budget items or product groups by area.
- Analysts: shows categories as nested rectangles sized by value, conveying share through area.
What it needs
One column with the category labels and one with the numeric values to compare.
How to use it
- Select the data range or table you want to visualize.
- Open the Charts (Visualizations menu) gallery from the XLMind Plus tab.
- Pick the Treemap 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 chart shape (auto-refresh and edit).
Effect on your data and undo
Treemap does not change your source data; the result is added as a separate item. It refreshes automatically when the linked cells change. Undo Last reverses it whenever you need.
How it differs from similar tools
It creates this chart type without helper columns, tricks or macros; the result stays bound to your data and remains hand-editable.
Good to know
Bindings must match the chart's expected shape; auto-refreshes on source change. Requires the listed data fields (category, value).
Limitations
Requires the listed data fields.
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 my source table modified?
- No. The tool only reads your data; the only addition to the sheet is the visual itself.
- 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
- At the other end of the family sits Charts
- As a next step, use Create Dashboard
- Often used alongside this tool: KPI Cards
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.