Forum Discussion

Joysome12's avatar
Joysome12
Copper Contributor
Jan 19, 2020

Gridlines in Excel Chart

How do I hide the grid lines in a excel chart.  I have created a scatter plot and now want to remove its grid lines.  I'm using Excel 2016 for Mac.

  • Joysome12 

    I'm on a Mac, though using a more modern version of Excel. Unless I'm totally mistaken, I believe it's similar in the 2016 version. Perhaps the pictures below can lead you to the solution you seek.

    Find the icon looking like this and press it.

     

     

  • Hello,

    1. Click on the plus icon located top right of the chart
    2. Uncheck the Gridlines box

    Alternatively, select the gridline in the plot area of that chart and hit delete on your keyboard
  • Joysome12's avatar
    Joysome12
    Copper Contributor

    Thank you.  The second method worked.  I don't have a plus sign at the top right from the chart.  I clicked on the grid line and hit delete.

     

    Now, how do I get the grid lines to show if I want to show them again?

  • Joysome12's avatar
    Joysome12
    Copper Contributor

    I'm using Excel 2016 for Mac.  I don't think your solution applies to this version of Excel.  I'm not finding Table Design.  And, the article you sent a link to does not pertain to Excel 2016 for Mac.

     

    I'm needing to know how to hide and show gridlines in a chart in excel.

     

    I'm using Excel 2016 for Mac

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor

      Joysome12 

      I'm on a Mac, though using a more modern version of Excel. Unless I'm totally mistaken, I believe it's similar in the 2016 version. Perhaps the pictures below can lead you to the solution you seek.

      Find the icon looking like this and press it.

       

       

  • Joysome12's avatar
    Joysome12
    Copper Contributor

    Thank you very much everyone!  I'm now able to easily show and hide the grid lines in a chart in Excel.

Resources