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.

Download and connect to the sample data source. We are making this chart using 2 dimensions and 1 measure.

Contents

• Build a Treemap Chart
• Show Measure Values
• Show or Ignore Negative Values
• Other Actions

Build a Treemap Chart

To build a Treemap Chart

1. Connect to the sample data source in Aqua Data Studio.
2. From the Dimensions pane, select Coffee and Geography.
3. From the Measures pane, select Freight.
4. Click the  tab and then click.Visualization builds a Treemap Chart.
   

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.

Visualization moves Coffee and Geography to the Labels Deck and Freight to Color Deck. If you click the Label Deck, Show Data Labels are selected by default. Now, in the Color Deck, replace Freight with Geography and apply a filter to both Coffee and Geography dimensions.

Show Measure Values

Labels are useful for understanding plotted data. When Visualization builds a Treemap chart, the data labels are displayed on the chart but to see the percentage values, you have to select the Show Measure Values check box from the Label Deck. Alternatively, right-click Freight, then point at Label and then turn on Show Measure Values. To know more, see Chart Properties Label. 

To show data labels

1. In the Chart Properties area, click Label.
   
2. Select the Show Measure Values check box. Visual Analytics displays Freight values for different territories in different geographies.

Include Negative Values

Your data may contain a mixture of both negative and positive values. By default, Visualization does not include negative values while building the chart.

To include negative values

1. In the Chart Properties area, click Options.
   
2. Click the Use absolute values option. As Visual Analytics changes all negative values into absolute values, the total profit for coffee appears more as compared to when Visualization ignored negative values.

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.
• You can use various ways of showing and hiding labels from the chart view. For more information, see Chart Properties Label.