Share via


Displaying a Series with Multiple Data Ranges on a Chart (Report Builder and SSRS)

Chart will use the minimum and maximum values of a series to calculate the axis scale. When a series on your chart contains more than one range of data, the data points can become obscured, and only a few data points to be seen easily on the chart. For example, suppose a report displays daily sales totals over a period of 30 days.

Chart with multiple data ranges

For most of the month, the sales are between 10 and 40. However, a one-week sales marketing campaign has caused a sudden sales increase at the beginning of April. This change in sales data produces an uneven distribution of data points that reduces the overall readability of the chart.

There are different ways to improve readability:

  • Enable scale breaks. If your data forms two or more sets of data ranges, use a scale break to remove the gap between the ranges. A scale break is a stripe drawn across the plotting area to denote a break between the high and low values of a series.

  • Filter out unnecessary values. If you have data points that are obscuring the important data range to be displayed on the chart, remove the unwanted points using a report filter. For information on how to add a filter to the chart in Reporting Services, see Add Dataset Filters, Data Region Filters, and Group Filters (Report Builder and SSRS).

  • Plot each data range as a separate series for multiple series comparison. If you have more than two data ranges, consider separating the data ranges into separate series. For more information, see Multiple Series on a Chart (Report Builder and SSRS).

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.

Displaying Multiple Data Ranges Using Scale Breaks

When you enable a scale break, the chart calculates where to draw a line across the chart. You must have sufficient separation between ranges to draw a scale break. By default, a scale break can be added only if there is a separation between the data ranges of at least 25% of the chart.

Chart with scale break

Note

You cannot specify where to place a scale break on a chart. You can, however, modify how the scale break is calculated, described later in this topic.

If you enable a scale break but it does not appear, even though there is sufficient distance between the data ranges, you can set the CollapsibleSpaceThreshold property to a value less than 25. The CollapsibleSpaceThreshold specifies the percent of collapsible space required between the data ranges. For more information, see Add Scale Breaks to a Chart (Report Builder and SSRS).

Charts support up to five scale breaks per chart; however, displaying more than one scale break can cause the chart to become unreadable. If you have more than two data ranges, consider using a different method for displaying this data. For more information, see Multiple Series on a Chart (Report Builder and SSRS).

Unsupported Scale Break Scenarios

Scale breaks are not supported in the following chart scenarios:

  • The chart is 3-D enabled.

  • A logarithmic value axis has been specified.

  • The value axis minimum or maximum has been explicitly set.

  • The chart type is polar, radar, pie, doughnut, funnel, pyramid, or any stacked chart.

An example of chart with scale breaks is available as a sample report. For more information about downloading this sample report and others, see SQL Server 2012 Report Builder and Report Designer sample reports.

See Also

Tasks

Collect Small Slices on a Pie Chart (Report Builder and SSRS)

Reference

Axis Properties Dialog Box, Axis Options (Report Builder and SSRS)

Concepts

Multiple Series on a Chart (Report Builder and SSRS)

Formatting a Chart (Report Builder and SSRS)

3D, Bevel, and Other Effects in a Chart (Report Builder and SSRS)

Charts (Report Builder and SSRS)