Chart display settings dialog (Charts)

To open the Chart display settings dialog, do one of the following:

Click Chart options and select Chart display settings.
Select View menu> Chart options> Chart display settings.

Choose a chart type

To change the chart type, select a type and click OK.

When you select a chart type, the picture changes to illustrate the chosen type.

Show slicer area in one line

If selected, all slicer dimension tiles display side by side in the slicer area. Scrolling may be required to see them all. Otherwise slicer dimensions stack as required to fit in the current window.

Show data labels

If selected, labels appear beside the data points in a chart.

Scale break

If selected, scale breaking will be applied.

Scale breaking prevents unusually large values from making the other values appear too small.
In Threshold, enter the point at which you wish the scale to break. You can choose 25%, 50%, or 75% of the highest value shown on the axis. Values which are greater than the others by at least that amount will show a broken scale.