Working with the Chart Builder

You can use the Chart Builder to change the chart type and to customize a chart.

The Chart Builder has different types of shelves (measures, dimensions, and trellis) for each chart type. Measures and dimensions can be dragged or added to shelves.

Table 1: Measure shelves

Measure shelf

Description

Area Color

The color used for each area in a map chart

Area Weight

The weighting to give to each area in a tree map

Axis

An X or Y axis of a bar and column chart, line chart, scatter chart, bubble chart, box plot, radar chart, or waterfall chart. Multiple axis shelves may be available.

For example, when you select a Bar Chart With 2 X-Axes, the X Axis1 and X Axis2 shelves appear.

Bubble Width

The width of a bubble in a bubble chart

Column Width

The width of a column in a marimekko chart

Measures

The measures that are displayed in a crosstab. You can move the Measures token to the Rows or Columns shelf to choose where the measures appear.

Pie Depth

The thickness of each section in a pie with depth chart

Pie Sectors

The sections in a pie chart

Primary Values

The primary values in a table, funnel chart, or parallel coordinates chart

Value

The primary value used in a funnel chart or the number displayed in a geographic chart or numeric point chart

Word Color

The color of text in a tag cloud

Word Weight

The weighting of text in a tag cloud

Table 2: Dimension shelves

Dimension shelf

Description

Animation

Adds an animation to a scatter chart. When you select the play button below a chart, the chart cycles through the values of the dimension added to this shelf.

Area Name

The label used for each area in a map chart

Axis

An axis of a bar and column chart, line chart, box plot, or waterfall chart. Multiple axis shelves may be available. For example, if you select a Bar Chart, the Y Axis shelf appears.

Category

A section of data in a funnel chart or parallel coordinates chart

Color

The color of a data point in a geographic chart

Geography

A data point in a geographic chart

Legend Color

The colors in a legend for a bar and column chart, line chart, pie chart, scatter chart, box plot, or radar chart. The colors in a chart automatically update to match its legend.

Legend Shape

The shape of each entry in a legend and of each data point for a scatter chart or radar chart

Network Link

The nodes in a network chart

Overlay Data

An extra data overlay in a geographic pie chart. When multiple dimensions are added, pie charts are created on the geographic map.

Radar Branches

The quantitative variables represented on axes starting from the same point in a radar chart

Rows Axis

An axis of a row in a table

Tree Node

The nodes in a tree chart

Word

The text displayed in a tag cloud

Table 3: Table and crosstab shelves

Table or crosstab shelf

Description

Columns

The column axis of a crosstab. You can add dimensions to this shelf, and move the Measures token to this shelf to display measures on the columns.

Rows

The row axis of a crosstab. You can add dimensions to this shelf, and move the Measures token to this shelf to display measures on the rows.

Rows Subtotals

Adds a subtotal to the rows in a table or crosstab

Table 4: Trellis shelvesA trellis chart is a set of small charts shown in a grid for comparison. Each small chart represents one item in a section. For example, if you create a bar chart that compares revenue by region, and then add the <Country> dimension to the trellis, multiple small charts appear. Each small chart displays the revenue by region for one country.

Trellis shelf

Description

Rows

The rows in a trellis chart. For example, if you place the <Year> dimension on the Rows shelf, the trellis chart will contain a row for each year in the <Year> dimension.

Columns

The columns in a trellis chart. For example, if you place the <Year> dimension on the Columns shelf, the trellis chart will contain a column for each year in the <Year> dimension.