Gridlines

<< Click to Display Table of Contents >>

Gridlines

You can show gridlines to make the values in a chart easier to read. (For more information, see Showing/hiding gridlines.)

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.

Edit properties: To change the properties of the major grid of the value axis, for example, select one of its gridlines, right-click it to open the context menu and choose the command Value axis major gridlines: Properties.

Tip: Alternatively, you can chose this command via the Edit properties icon chart_edit_element_icon on the ribbon tab Chart.

You can make the following settings:

Format tab

Tip: The appearance of the lines can also be conveniently adjusted directly via the buttons of the ribbon tab Chart | group Chart elements. For more information, see Editing chart elements.

Line section

Here, you can change the line style used to draw the gridlines. Auto uses thin gray standard lines. None removes the lines. The option Custom lets you customize the line style.

Changing the scale of gridlines

To change the distances between the gridlines, select the corresponding axis, choose its properties and make the desired changes on the Scale tab.