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.
|
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
|
|
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 |
|
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 or crosstab shelf |
Description |
|---|---|
|
Columns |
The column axis of a crosstab. You can add dimensions to this shelf, and move the
Measures
|
|
Rows |
The row axis of a crosstab. You can add dimensions to this shelf, and move the
Measures
|
|
Rows Subtotals |
Adds a subtotal to the rows in a table or crosstab |
|
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. |