Three‑dimensional Bar Charts

You can add more information to your bar chart by adding an additional item or items to the z pane in the data layout. Using multidimensional charts, you can show various relationships between three or more items in easy-to-understand bar chart formats.

Interactive Reporting plots the added data in rows that extend back along the z axis of the chart.

Dragging a label item to the Stack, Cluster or Depth category (in this case, Year) plots an extra dimension.

To create a three-dimensional bar chart:

Select a bar chart format from the Chart drop-down list box.
The default chart format is Vertical Bar.
Drag a label item from Elements to the x pane in the data layout.
Drag a label item from Elements to the z pane in the data layout.
Drag a value from Elements to the y pane in the data layout.
A chart is plotted that summarizes the selected value y pane as it relates to the subcategories of the label items (x axis and z axis).

To display line values, select Show Line Values on the shortcut menu.

To display bar values:

Select Show Bar Values on the shortcut menu.
Select the placement of values on the bar:
- Inside
- Over
- Outside
- None

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.