You can change your chart perspective so that the z axis data extended in the third dimension is shown as clusters displayed in the foreground. This charting option is useful when the z axis bars are hard to distinguish in standard bar formats.
You can use clustered bar charts to juxtapose categories in one label item. For example, use clustered bars to compare stores of different types. Alternatively, cluster bars can be used to compare two different value items, such as Amount of Sales and Units Sold.
Note: | You can only display clustered bar charts in vertical format. |
To cluster bars representing divisions in label items (clustered on the z axis):
Select Vertical Cluster Bar from the Chart Type drop-down list box.
Drag a fact item from Elements to the y pane and label items to the z axis and x axis panes in the data layout.
To cluster bars representing two different value items (clustered on the y axis):
Select Vertical Cluster Bar from the Chart drop-down list box.
Drag two fact items to the y axis and a label item to the x axis.
To display bar values:
Select Show Bar Values on the shortcut menu.
Select the placement of values on the bar:
To show the gap between bars, click a bar and select Show Bar Gap on the shortcut menu.
To show the borders of a bar, click a bar and select Show Bar Border on the shortcut menu.