To enable scale breaks on the chart1. Right-click the vertical axis and then open "Axis Properties".
2. Select the "Enable scale breaks" check box.
To change the style of the scale break
1. On the design surface, right-click on the y-axis of the chart. The properties for the y-axis object are displayed in the Properties pane.
2. In the Scale section, expand the ScaleBreakStyle property.
3. Change the values for ScaleBreakStyle properties, such as BreakLineType and Spacing.
Note: You cannot specify where to place a scale break on your chart. The chart uses its own calculations based on the values in your dataset to determine whether there is sufficient separation between data ranges to draw a scale break on the value axis (y-axis) at run time.





