Selecting Chart Display Settings

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.

Fixed headers on scrolling

• If selected, headers are "frozen." Fixed headers always remain visible when you scroll your data.

Maximum length of column labels

• Enter a maximum length, if desired. This specifies a maximum number of characters for a label. Headers will be truncated to the desired length and any missing parts will be replaced with an ellipsis (...). You can still read the entire header in a tooltip by hovering over it with your mouse.
  
  Note: If column nesting is in effect, the label for the outermost (top) column dimension will not be truncated.

Label wrapping

• If selected, long labels will wrap to the next line. (Very long labels can make columns too wide. This can prevent much data from being displayed on screen.)
  
  Note: If this option is selected, you cannot also select "Fixed headers on scrolling."

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.