Showing and Hiding Grid Lines 

Use

You can make it easier to read values by displaying major and minor gridlines for both the X and Y axes. You can also define the axes (main axis, secondary axis) for which the grid lines should be displayed.

Prerequisites

The chart is neither a pie chart nor a doughnut.

Procedure

  1. Click with the right mouse key on any area of the chart.
  2. In the context menu, choose Chart Options.

    3. This brings you to the dialog box with the same name.

  3. Choose tabstrip Gridlines.
  4. Select the Major gridlines and Minor gridlines you want to display.
  5. Deselect the gridlines you want to hide.
  6. Choose OK.