Bar: Layout category

In the Layout category for Bar graphs, some or all of the following options are available depending on what type of Bar graph you are formatting:

Type: Allows you to select a Layout type of Absolute, Clustered, Stacked, Percent, or True 3D Column.
Absolute: Displays bar risers on top of each other to show the absolute relationships between data series.
Clustered: Displays a clustered or a side-by-side group of bars. This is the standard type of two-dimensional Bar graph.
Stacked: Stacks the bar risers on top of each other. The axis is the cumulative total of all the groups.
Percent: Displays a bar version of a Pie chart. Each group calculates the percent of the total required for each series. The axis goes from zero to 100%.
True 3D Column: Shows trend information along a series. Creates a three-dimensional graph. (This option is not available for any of the Horizontal Bar graph styles.)
Dual Axes: For Absolute, Stacked, and Clustered bar graphs, displays the bar graph with two numeric axes (Y1 and Y2). This allows you to chart some of the series on one axis and some of the series on another axis.
Split Dual Axes: Splits the graph and shows two separate numeric axes; divides the series between two physical axes in the graph. When the Dual Axes check box is selected, half of the series in the graph are on the primary numeric axis (Y1) and the other half on the secondary numeric axis (Y2). However, all risers are drawn from a single category axis base line. The series assigned to the Y1 and Y2 axes are drawn on opposite sides of the graph.

Related Topics