A Range chart displays sets of data points, each of which is defined by multiple values for the same category, and emphasizes the distance between the two values.
The category labels are displayed on the category axis. The plain Range chart fills in the area between the top and the bottom value for each data point.
The following image displays a plain Range chart with one Range Area series:
- Column range—The Column Range chart uses columns to represent the range.
- Bar range—The Bar Range chart uses bars to represent the range.
- Smooth range—A Smooth Range chart uses curved lines to connect data points rather than straight ones.
In this section, you will create a Range Area chart.
To add a new Graph report item to the report, refer to the article getting started with the Graph report item.
Now you can set the SeriesGropus hierarchy of the Range Area chart:
- Open the SeriesGroups collection editor and click Add. By default, this will add a new static group (group without grouping).
- Set the Name to
Next, you will have to define the CategoryGroups hierarchy of the Range Area chart:
- Open the CategoryGroups collection editor and click Add.
- Set the Groupings to
- Set the Sortings to
- Set the Name to
Here you will specify the coordinate system details:
- Open the CoordinateSystems collection editor and Add a new CartesianCoordinateSystem.
- Leave the Name to
- Set the XAxis to New Axis with Category Scale.
- Set the YAxis to New Axis with Numerical Scale.
In this step, you will configure the series of the chart:
- Open the Series collection editor and Add new AreaSeries.
- Set the CategoryGroup to categoryGroup1.
- Set the SeriesGroup to seriesGroup1.
- Set the CoordinateSystem to cartesianCoordinateSystem1.
- Set the Y value to
=Sum(IIF(Fields.OrderDate.Year=2002, Fields.TotalDue, 0)).
- Set the Y0 value to
=Sum(IIF(Fields.OrderDate.Year=2003, Fields.TotalDue, 0)).
To set the color palette, format the labels, define the values of the legend, and elaborate on any other styling options, refer to the section on formatting the Graph.
- Range charts require two values per data point. These values represent a high value and a low value that define the range for each data point.
- If only one value is specified, the Range chart will display as if it were a regular Area, Bar, or Column chart with a single value per data point.
- Range charts are often used to graph data that contains minimum and maximum values for each category group in the dataset.
- It is not recommended to display markers on each data point in a Range chart.
- Like the Area chart, in a plain Range chart, if the values in multiple series are similar, the series will overlap. In this scenario, you may want to use a Column Range or Bar Range chart instead of a plain Range chart.
- You can create Gantt charts by using a Range Bar chart.