+ Reply to Thread
Results 1 to 5 of 5

Gridlines on a line graph

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Gridlines on a line graph

    Hi, on my linegraph that I have produced I have selected to show major and minor lines on both horizontal and vertical axis. The horizontal lines show 4 minor lines between each major and the vertical lines only show 1 minor between each major. Is there a way of displaying 4 lines between each major on the vertical? Many Thanks Laz

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Gridlines on a line graph excel 2010 HELP!!

    Try seting the intervals on the axis tick marks to fixed and specifying a ratio of 4:1 for major and minor.

    Then add your minor gridlines.
    Martin

  3. #3
    Registered User
    Join Date
    11-20-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Gridlines on a line graph excel 2010 HELP!!

    It only seems to give me the options to select fixed intervals on the vertical axis, the horizontal axis is giving me different options. I have attached a copy of my graph so that you can see if there is a reason why im not able to solve the problem
    Attached Files Attached Files

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Gridlines on a line graph

    You are using a line graph which has categories along the X axis rather than values. As your load figures increment by one each time, this works OK. If you didn't have a regular set of load values, your graph would not adjust to reflect this.

    You need to try a scatter graph instead in which case the axes are treated in the same way.

  5. #5
    Registered User
    Join Date
    11-20-2011
    Location
    Kent, England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Gridlines on a line graph

    Excellent that has worked perfectly, it makes sense when you think about it. Thank you very much for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1