Showing/hiding gridlines |
  
|
Showing/hiding gridlines |
|
Showing gridlines in a chart can improve the legibility of its values. Gridlines are a network of lines that extend across the plot area, starting from one of the axes of the chart.
The following types of gridlines are available:
▪Major gridlines are indicated at every major tick mark on the axis.
▪Minor gridlines subdivide the major grid into an even finer grid if necessary.
You can enable gridlines separately for each axis.
To show or hide gridlines, proceed as follows:
Via the "Add chart element" icon
Select the chart and use the ribbon command Chart | Add chart element 
to choose the entry Gridlines. In the following submenu, you can enable or disable horizontal (for the Y axis) and vertical (for the X axis) major gridlines and minor gridlines for the primary axis. A check mark in front of them indicates the gridlines which are currently enabled.
The entry More takes you to the dialog box with additional options (see below).
Via the dialog box
For additional options (for example, gridlines for secondary axes), choose the path via the dialog box:
| 1. | Select the chart by clicking on it. |
| 2. | Use the ribbon command Chart | Add chart element to choose the entry Gridlines and select More in the following submenu to open the dialog box. |
| Alternatively: Right-click to open the context menu and select the entry Chart: Properties. |
| 3. | Switch to the Elements tab and enable the option Major grid and/or Minor grid for the desired axes. |
For more information on editing gridlines, see Gridlines.