Range Charts (Report Builder and SSRS)

  • Article

A range chart type displays a set of data points that are each defined by multiple values for the same category. Values are represented by the height of the marker as measured by the value axis. Category labels are displayed on the category axis. The plain range chart fills in the area between the top and bottom value for each data point.

The following illustration shows a plain range chart with three series.

Range chart

Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

Variations

  • Smooth range. A smooth range chart displays curved lines rather than straight.

  • Column range. A column range chart uses columns instead of areas to display the ranges.

  • Bar range. A bar range chart uses bars instead of areas to display the ranges.

Data Considerations for Range Charts

  • Range chart types require two values per data point. These values correspond with a high value and a low value that defines the range for each data point.

  • Range charts are useful for analysis only if the top values are always higher than the bottom values. If this is not the case, consider using a line chart. If the high value is lower the low value, the range chart will display the absolute value of the difference between these values.

  • If only one value is specified, the range chart will display as if it were a regular area chart, with one 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.

  • Displaying markers on each data point is not supported on the 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.

  • Gantt charts can be created using a range bar chart.

See Also

Charts (Report Builder and SSRS)
Chart Types (Report Builder and SSRS)
Formatting a Chart (Report Builder and SSRS)