How to Make a Treemap Chart

A simple Treemap Chart is created by dragging a Measure in the Rows deck and dividing it into areas by dragging Dimensions into the Chart Properties Break and Color buttons. Treemap Charts are useful for showing hierarchical data by representing it as nested rectangles.

1. Execute a select * from bistudio_example within the query analyzer on the bistudio_example.xlsx file

2. Click the [Visual Analytics] icon in the Query Analyzer Grid Results toolbar.

3. Select Treemap from the Chart Properties dropdown.

4. Drag Freight from the Measures Pane to Rows.

5. Drag Territory from the Dimensions Pane to the Break and Label buttons in the Chart Properties.

6. Drag Sales Reason from the Dimensions Pane to the Color and Label buttons in the Chart Properties.

The order of hierarchy formed in Treemap is based on the placement of dimensions in the Label Deck. You can rearrange the fields in the Label Deck, to change the order of grouping on the chart.

Other Actions

• You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
• You can use highlight actions to focus on selected treemap rectangles. Visual Analytics makes the highlighted rectangles and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
• You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
• You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.