Add Scale Breaks to a Chart (Report Builder and SSRS)
Applies To: SQL Server 2016
A scale break is a stripe drawn across the plotting area of a chart to denote a break in continuity between the high and low values on a value axis (usually the vertical, or y-axis). Use a scale break to display two distinct ranges in the same chart area.
An example of a chart with scale breaks is available as a sample report. For more information about downloading this sample report and others, see SQL Server 2016Report Builder and Report Designer sample reports.
Right-click the vertical axis and then click Axis Properties. The VerticalAxis Properties dialog box opens.
Select the Enable scale breaks check box.
Open the Properties pane.
On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object (named Chart Axis by default) are displayed in the Properties pane.
In the Scale section, expand the ScaleBreakStyle property.
Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing. For more information about scale break properties, see Displaying a Series with Multiple Data Ranges on a Chart (Report Builder and SSRS).