Range Chart

In This Topic

The Range Chart can display 2D or 3D shapes defined by the begin / end values of their bounding boxes. It can be used for display of histograms, bars with custom sizes, 3D ranges etc.

Settings

Sub Type - the following table summarizes the different subtypes of the range chart:

Subtype	X Dimension Type	Z Dimension Type	Data Requirements	Description
Series	Categorical	Categorical	Y1 Y2	A line is drawn from Y1 to Y2. Both points have the same X value.
XY Scatter	Numeric	Categorical	Y1 X1 Y2 X2	A rectangle is drawn from [X1, Y1] to [X2, Y2].
XYZ Scatter	Numeric	Numeric	Y1 X1 Z1 Y2 X2 Z2	A box is drawn from [X1, Y1, Z1] to [X2, Y2, Z2]. You need to switch the chart mode to 3D.

Subtype

X Dimension Type

Z Dimension Type

Data Requirements

Description

Series

Categorical

Y1
Y2

A line is drawn from Y1 to Y2. Both points have the same X value.

XY Scatter

Numeric

Categorical

Y1
X1

Y2
X2

A rectangle is drawn from [X1, Y1] to [X2, Y2].

XYZ Scatter

Numeric

Y1
X1
Z1

Y2
X2
Z2

A box is drawn from [X1, Y1, Z1] to [X2, Y2, Z2]. You need to switch the chart mode to 3D.

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

Automatic Data Labels Positioning

The automatic positioning of data labels is the data point center.

Automatic Legend Mode

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