+ Reply to Thread
Results 1 to 3 of 3

Thread: Is it possible to format an individual gridline?

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Is it possible to format an individual gridline?

    I'd like to choose a different thickness and/or colour for one particular y-axis gridline (horizontal) in my XY scatter chart, just that y-axis gridline and not any of the other y-axis gridlines. Is this possible and if so how is it done?

    Thanks
    Last edited by Doctor Wu; 01-06-2012 at 03:26 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007, 2010
    Posts
    25,770

    Re: Is it possible to format an individual gridline?

    Not possible, but you could add a two-point series that overlays it and format as you like.
    Last edited by shg; 01-06-2012 at 03:18 PM.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Is it possible to format an individual gridline?

    Thanks very much shg, worked like a charm!

+ 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.2.0