Treemaps show the relationship between two measures, represented by size and color, and their variance across a dimension. This compact visual format lets you spot critical performance trends, large contributors, and unexpected outliers at a glance without reading through crowded numerical tables.

A treemap arranges hierarchical data into proportionate rectangular tiles. Each tile represents an individual item or category, such as a product line, sales territory, or expense group. For example, a treemap can plot sales against profits across the top ten U.S. states. In this example, the area size represents total sales. The color shows how profitable sales were in that area. 

A treemap communicates two key values at the same time:

  • Size: The physical area of each rectangle reflects a primary quantitative measure, such as gross sales volume, budget allocation, or headcount. Larger rectangles indicate larger numbers.
  • Color: The fill color and shade intensity reflect a secondary quantitative measure, such as profit margin, percentage growth, or variance against target.
Treemap of sales against profit

You can build a treemap from three data sources: Model-Based, Relational, or Excel Range.

  • Model-Based: A multidimensional model (such as Anaplan or Microsoft Analysis Services). When you select a cube source, Anaplan XL displays the standard member selector, where you place hierarchies into dedicated functional areas:
    • Plot: Contains the dimension hierarchy that forms the rectangles in the workbook.
    • Header: Contains context dimensions that slice and filter the data, such as a specific fiscal year or currency.
  • Relational: A table with named columns. Anaplan XL treats table data like a standard range: the leftmost columns provide the categorical hierarchy, and the last two columns supply the size and color values.
  • Excel range: A standard cell selection on an Excel worksheet. You structure your data in adjacent columns. The initial columns contain descriptive member labels (such as Category and Subcategory), while the final two columns supply the numeric values for size and color.

When you source a treemap from a cube or model, you get the usual Anaplan XL member selector.

  • Plot area: Define a hierarchy here. This determines the areas Anaplan XL plots.
  • Header area: Slice the results. For example, it can show only data for a given time period.
  • Behaviour tab: Controls the data displayed.
  • Values section: Choose the measures used for the treemap's size and color. Measures make up the default hierarchy, but you can drop in a different one if needed. You can also select number formats for the values. The Apply Cube formatting option overrides these if you select it.
  • Split by section: defines a two-level treemap. The second level can be a lower level of the hierarchy you chose to plot, or it can be a different hierarchy entirely.

Relational and Excel Range data sources work almost the same way. In both, you select multiple columns. Anaplan XL treats the last two columns as size and color values and uses the remaining columns as member values.

You can include several member columns. Anaplan XL then lets you drill down into the data.

Example: Start with a Relational or Excel Range data source in Excel to build a treemap. The treemap begins at the top level. Double-click an area to drill in and see more detail.

You can create a treemap, which starts at the top level:

The Behaviour tab and data controls in the Design Treemaps window let you customize how Anaplan XL calculates, groups, and maps values:

OptionDescription
Show second levelDisplays child tiles directly within each parent rectangle. For instance, an outer rectangle displays an entire product category, while smaller tiles inside it display individual subcategories.
Total size usingSets the mathematical method used to aggregate child sizes into the parent tile. While the default method is the sum of all children, you can choose alternative aggregations, such as an average.
Total colour usingSets the mathematical method used to aggregate color metric values. This option is essential when plotting rates or percentages (such as profit margins), where an average of child values provides an accurate figure rather than a direct sum.
ValuesSpecifies the exact measures assigned to the size metric and color metric. You can also define custom number formats for each measure or select Apply cube formatting to preserve formatting defined in the model.
Split byDefines the hierarchy or dimension used to construct a two-level nested treemap. You can select a lower level of the plotted hierarchy or introduce an entirely different dimension.

The layout and styling settings control how rectangles are organized and colored across the chart canvas:

OptionDescription
GradientSelects the visual color palette for the treemap. A gradient creates smooth color transitions from lowest to highest values. You can select the Reverse color order checkbox when lower numbers represent positive performance, such as tracking customer churn or operating expenses.
Layout

Determines the geometric arrangement of tiles

    • Order by size: Positions the largest rectangles first, typically starting from the upper left and progressing to the lower right.
    • Natural order: Maintains the original sorting order from the source table, Excel range, or dimensional cube.
    • Squares: Uses a squarified tiling algorithm that shapes rectangles as close to squares as possible, making visual size comparisons much easier for the human eye.


Parent name positionSpecifies where the title label appears (such as top, bottom, or header bar) when you enable two-level display.

Treemaps in Anaplan XL offer interactive controls that connect visual charts to the rest of your workbook:

OptionDescription
Output rangeDefines a specific cell or range on your worksheet where Anaplan XL writes the name of the clicked rectangle. This enables the treemap to act as an interactive filter that updates connected grids, formulas, or auxiliary charts whenever a user selects a tile. If your treemap contains nested hierarchies, you can specify a multi-cell range to capture member names at each hierarchy level.
Link toPairs with the output range to jump the user's cursor directly to a connected section of the workbook when they select a rectangle.
Show back/forward controlsAdds navigation arrows to the treemap header, allowing users to move backward and forward between hierarchy levels during drill-down exploration.

You can customize the labels and figures displayed within each rectangle:

OptionDescription
Custom placeholdersUse text tokens to embed live values inside the tiles. Common placeholders include %sizemeasure% for the size value and %colormeasure% for the color value. For SQL or tabular sources, reference fields using %fieldName% or %valueN% (where value1 represents size, value2 represents color, and higher numbers represent extra data attributes).
Format sheet stylingCustomize fonts, text colors, and background styles globally or per object by configuring entries in your workbook format sheet. Setting the item name to the specific treemap name applies unique formatting, while setting it to Treemaps applies consistent styles to all treemaps across the workbook.