Bar Chart

In This Topic

A Bar Chart displays a sequence of vertical or horizontal bars (shapes) of lengths proportional to the value that they represent. Bar charts are usually used for comparing two or more values or representing the contribution of each value to a total (stacks). Following is a description of the bar chart settings:

Settings

Sub Type - The following table summarizes the different subtypes of the bar chart type:

Subtype	X Dimension Type	Z Dimension Type	Data Requirements		Description
Subtype	X Dimension Type	Z Dimension Type	First in Chart	Next in Chart	Description
Classical - displayed in both 2D and 3D. The X dimension type is always Categorical.
Clustered	Categorical	One	Value	Value	Shows series side by side.
Stacked	Categorical	One	Value	Value	Piles series on top of each other. Supports negative values.
Stacked Percent	Categorical	One	Value	Value	Piles series on top of each other and scales each pile to 100%.
Series	Categorical	Categorical	Value	Value	Shows series behind each other (best viewed in 3D).
Histogram - displayed in both 2D and 3D. The X dimension type is always Numeric.
Histogram	Numeric	Categorical	Value	Value	Show the histogram of the data point values. The following options are available: Interval Mode - possible values are Count and Width. The Count allows you to specify the count of the histogram bins whereas the second mode allows you specify the width of the histogram bins. Interval Count - the number of bins in the histogram (regarded when Interval Mode is set to Count). Interval Width - the width of histogram bins (regarded when Interval Mode is set to Width). Round Interval - whether to round the automatically computed histogram bin width (regarded when Interval Mode is set to Count). Round Range Begin - whether to round the histogram range begin value. Round Range End - whether to round the histogram range end value.
XY Scatters - displayed in both 2D and 3D. The X dimension type is always Numeric.
XY Scatter	Numeric	Categorical	Value X	Value X	Besides the value, each bar has a X coordinate at which it is positioned.
XY Scatter Clustered	Numeric	One	Value X	Value	The first in chart defines the cluster X position. Next in chart are arranged side by side relatively to this position.
XY Scatter Stacked	Numeric	One	Value X	Value	The first in chart defines the stack X position. Next in chart piled on top. Supports negative values.
XY Scatter Stacked Percent	Numeric	One	Value X	Value	The first in chart defines the stack X position. Next in chart are piled on top. Each pile is scaled to 100%.
XYZ Scatters - need 3D to be displayed correctly. The X and Z dimension types are always Numeric.
XYZ Scatter	Numeric	Numeric	Value X Z	Value X Z	Besides the value, each bar has a X and Z coordinate at which it is positioned in the XZ plane.
XYZ Scatter Clustered	Numeric	Numeric	Value X Z	Value	The first in chart defines the cluster XZ position. Next in chart are arranged side by side relatively to this position.
XYZ Scatter Stacked	Numeric	Numeric	Value X Z	Value	The first in chart defines the stack XZ stack position. Next in chart are piled on top. Supports negative values.
XYZ Scatter Stacked Percent	Numeric	Numeric	Value X Z	Value	The first in chart defines the stack XZ position. Next in chart are piled on top. Each pile is scaled to 100%.

All subtypes support a Label value for each data point. The Y dimension is always Numeric.

Shape - specifies the shape of the bars. Possible values are: Bar, Cylinder, Cone, Inverted Cone, Pyramid, Inverted Pyramid, Ellipsoid, Smooth Edge Bar and Cut Edge Bar.

Edge Percent - defines the size of the edge in case the Shape is set to Smooth Edge Bar or Cut Edge Bar.

Width Percent - for classical subtypes the Width Percent defines the width of the bar or bar group in percents of the space available for each category. For XY and XYZ Scatters The Width Percent defines the width of the bar or bar group in percents of 1/10 of the chart width.

Depth Percent - for classical and XY scatter subtypes the Depth Percent defines the depth of the bars in the series in percents of the series size along the depth axis. For XYZ scatter subtypes the Depth Percent defines the depth of bars in percents of 1/10 of the chart depth.

Gap Percent - controls the gap (space) between the bars, when the subtype is set to one of the cluster modes.

The settings in the Palette tab are described in the Value Palette Settings topic.

Show Connector Lines - whether to show connector lines (lines connecting adjacent bars).

Connector Lines Stroke Style - the stroke style of the connector lines.

Automatic Data Labels Positioning

The automatic positioning of data labels in the case of all types of stacks is the data point center. In all other cases data labels are displayed on top of the data point.

Automatic Legend Mode

The automatic legend mode in all subtypes evaluates to series (e.g. the series is displayed in the legend).