Display Status Tab (Chart Options)
Use the Display Status tab to show or hide chart objects.
- Group Axis
- Select this check box to show or hide the group axis and its labels.
- Data Axis
- Select this check box to show or hide the data axis and its labels.
- Data2 Axis
- If the Dual Axes check box was selected on the Layout tab of the Chart Options dialog box, use this check box to show or hide the secondary numeric axis and its labels.
- Series Axis
- If a True 3D chart is selected on the Layout tab of the Chart Options dialog box or a 3D surface chart is selected, use this check box to show or hide the series axis and its labels.
- X-Axis
- In Bubble, Scatter, and Histogram charts, select this check box to show or hide the X-axis and its labels.
- Major Grid
- For each axis in the chart (Category, Value Axis, Secondary Value Axis, X-axis), select these check boxes to show or hide the major gridlines on each axis.
- Minor Grid
- For each axis in the chart (Category, Value Axis, Secondary Value Axis, X-axis), select these check boxes to show or hide minor major gridlines on each axis.
- Legend
- Select this check box to show or hide the chart legend. This option is not available in True 3D and Histogram charts.
- Data Labels
- Select this check box to show or hide data labels for all series in the chart. This option is not available in True 3D charts.
- Left Wall
- In 3D charts only, select this check box to show or hide the 3D cube left wall.
- Right Wall
- In 3D charts only, select this check box to show or hide the 3D cube right wall.
- Floor
- In 3D charts only, select this check box to show or hide the 3D cube floor.
Funnel Charts
You can show or hide chart objects on the Display Status tab of the Chart Options dialog box.
- Show Funnel Name
- Select this check box to show or hide the funnel name.
- Show Legend
- Select this check box to show or hide the chart legend.
- Funnel Labels
- Select this check box to show or hide data labels for each slice in a funnel chart.
Pie or Doughnut Charts
You can show or hide chart objects on the Display Status tab of the Chart Options dialog box.
- Show Pie Name
- In pie charts, the category label(s) are drawn below each pie. Select this check box to show or hide the pie name.
- Show Pie Total
- In doughnut (ring pie) charts, select this check box to show or hide the total value in the center of each pie.
- Show Legend
- Select this check box to show or hide the chart legend.
- Slice Labels
- Select this check box to show or hide data labels for each slice in a pie chart.
See Also
Chart Options Dialog Box