• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • Product ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
Techwalla
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Insert Minor & Major Grid Lines in Excel

How to Insert Minor & Major Grid Lines in Excel

March 31, 2015
By: C. Taylor
  • Share
  • Share on Facebook

Adding grid lines to Microsoft Excel charts helps to recognize data values by making it easier to line up points on the graph with the bottom left side of the scale. Major grid lines are bolder lines that distinguish scale milestones, such as increments of 5 or 100, depending on the scale of your chart. Minor grid lines fill in the gaps with lighter lines and represent smaller units, such as increments of 1. Excel allows you to add major and minor grid lines simultaneously, which may be vertical, horizontal or both.

Video of the Day

Step

Open your spreadsheet chart in Microsoft Excel.

Step

Click the chart to enable the Chart Tools at the top of the window.

Step

Click "Layout" tab in the Chart Tools menu group.

Step

Click "Gridlines" from the Axes group. Point to either "Primary Horizontal Gridlines" or "Primary Vertical Gridlines" and click "Major & Minor Gridlines" to add either horizontal or vertical lines, respectively. To add vertical and horizontal grid lines, perform the procedure for both axes.

Show Comments

Related Articles

Smart Health: 10 Smart Sensors to Improve Your Workout

Smart Health: 10 Smart Sensors to Improve Your Workout

Around The Home
Productivity
By: David Isaac
How to Make a Picture Smaller for Twitter

How to Make a Picture Smaller for Twitter

Around The Home
Entertainment
By: Shea Laverty
How Do I Pixelate an Image Using Microsoft Paint?

How Do I Pixelate an Image Using Microsoft Paint?

Around The Home
Productivity
By: David Weedmark
How to Print Address Labels in Excel

How to Print Address Labels in Excel

Around The Home
Productivity
By: Scott Shpak
How to Remove Grid Lines in Excel

How to Remove Grid Lines in Excel

Around The Home
Productivity
By: Carol Finch
How to Compress a Picture With Paint

How to Compress a Picture With Paint

Around The Home
Productivity
By: Aaron Parson
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2018 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.