Display or hide chart gridlines

To make the data in a chart that displays axes easier to read, you can display horizontal and vertical chart gridlines. Gridlines extend from any horizontal and vertical axes across the plot area of the chart. You can also display depth gridlines in 3-D charts. Displayed for major and minor units, gridlines align with major and minor tick marks on the axes when tickmarks are displayed. You cannot display gridlines for chart types that do not display axes, such as pie charts and doughnut charts.

Chart that displays horizontal, vertical, and depth gridlines

1    Horizontal gridline

2    Vertical gridline

3    Depth gridline

Display chart gridlines

  1. Click anywhere on the chart to which you want to add chart gridlines.

  2. On the Design tab, in the Chart Layouts group, click Add Chart Element, point to Gridlines, and then click the gridline option you want to display. You can rest your mouse pointer over each option to preview the gridline display.

    Selecting a gridline option on the Gridlines menu

    Note: Options will vary depending on your chart type. For example, if your chart is a 3-D chart, you will see Depth gridline options, and if your chart has a secondary horizontal axis, you will see Secondary horizontal and vertical gridline options.

Top of Page

Hide chart gridlines

  1. Click anywhere on the chart in which you want to hide chart gridlines.

  2. On the Design tab, in the Chart Layouts group, click Add Chart Element, point to Gridlines, and then click the gridline option you want to hide. You can rest your mouse pointer over each option to preview the gridline display.

    Selecting a gridline option on the Gridlines menu

    Alternatively, select the horizontal or vertical chart gridlines that you want to remove, and then press DELETE.

Top of Page

See also

Hide or show gridlines on an Excel 2016 worksheet

Show or hide gridlines on an Excel 2013 worksheet

Print gridlines in a worksheet

Change grid spacing in Word and PowerPoint

Display chart gridlines

  1. Click anywhere on the chart to which you want to add chart gridlines.

  2. On the Layout tab, in the Axes group, click Gridlines.

    Excel Ribbon Image

  3. Do one or more of the following:

    • For horizontal gridlines, click Primary Horizontal Gridlines, and then click the option that you want.

    • For secondary horizontal gridlines, click Secondary Horizontal Gridlines.

      Note: This option is only available for charts that display a secondary horizontal axis. For more information, see Add or remove a secondary axis in a chart.

    • For vertical gridlines, click Primary Vertical Gridlines, and then click the option that you want.

    • For secondary vertical gridlines, click Secondary Vertical Gridlines.

      Note: This option is only available for charts that display a secondary vertical axis. For more information, see Add or remove a secondary axis in a chart.

    • For depth gridlines on a 3-D chart, click Depth Gridlines, and then click the option that you want.

      Note: This option is only available when the selected chart is a true 3-D chart, such as a 3-D column chart.

Top of Page

Hide chart gridlines

  1. Click anywhere on the chart in which you want to hide chart gridlines.

  2. On the Layout tab, in the Axes group, click Gridlines.

    Excel Ribbon Image

  3. Do one or more of the following:

    • Click Primary Horizontal Gridlines, Primary Vertical Gridlines, or Depth Gridlines (on a 3-D chart), and then click None.

    • Click Secondary Horizontal Gridlines or Secondary Vertical Gridlines, and then click None.

      Note: These options are only available when a chart has secondary horizontal or vertical axes.

    • Select the horizontal or vertical chart gridlines that you want to remove, and then press DELETE.

Top of Page

See also

Show or hide gridlines on an Excel 2010 worksheet

Show or hide gridlines on an Excel 2007 worksheet

Print gridlines in a worksheet

Change grid spacing in Word and PowerPoint

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×