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

Note   This article covers working with gridlines in a chart. For more information about working with gridlines on a worksheet, see Hide or display cell gridlines on a worksheet and Print with or without cell gridlines.

What do you want to do?

Display chart gridlines

Hide chart gridlines

Display chart gridlines

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

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  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 to which you want to add chart gridlines.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  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.

      Tip   You can also right-click the gridlines, and then click Delete.

Top of Page

Applies To: Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language