Adding an Axis Break to a Chart

Axis breaks can be used to visually shorten outliers in bar/column or waterfall charts.

Context

When a chart has one or two bars that are significantly longer than the rest, the chart can be difficult to read. An axis break lets you shrink the longer bars and improve readability of the shorter ones.

Axis breaks can be added to the following chart types:
  • Bar/Column
  • Waterfall
Note

  • Axis break may not be available when the axis range is manually set.

    If you set an axis break and then edit the axis range, the axis break may be removed.

  • Selection is retained for drill-states.

  • You can have only one axis break in a chart.

Procedure

  1. In your chart, select one or more outlier measures.
  2. Right-click and then select Break Axis.

Results

An axis break is added to the chart. To remove it, select a measure and then click Disable axis break.
Related Information