+ Reply to Thread
Results 1 to 4 of 4

How to make y=0 gridline more prominent

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 365
    Posts
    36

    How to make y=0 gridline more prominent

    I have a graph with years on the x-axis and bank balance on the y-axis. The bank balance can be positive or negative, in my case it goes from -?400 to +?1,000.

    I want the y=0 gridline to be more prominent, e.g. bold. How can I do this while still showing the x-axis labels at the very bottom of the graph?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How to make y=0 gridline more prominent

    Have you tried formatting the x axis so that it crosses the y axis at 0 and the axis labels are set to "low" rather than the default "next to axis"?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,060

    Re: How to make y=0 gridline more prominent

    Create another series with zero values.

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    Manchester, England
    MS-Off Ver
    Excel 365
    Posts
    36

    Re: How to make y=0 gridline more prominent

    That's what I wanted, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Gridline Color
    By bj90 in forum Excel General
    Replies: 11
    Last Post: 07-23-2019, 10:27 AM
  2. Styling One Gridline Different Than Others
    By pjhawksr in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-18-2007, 11:12 AM
  3. [SOLVED] Gridline
    By Scott in forum Excel General
    Replies: 2
    Last Post: 06-08-2006, 09:20 AM
  4. Print gridline
    By pctalk in forum Excel General
    Replies: 0
    Last Post: 02-09-2006, 08:35 PM
  5. [SOLVED] Gridline printing
    By pbaldwin in forum Excel General
    Replies: 2
    Last Post: 08-16-2005, 09:05 PM
  6. [SOLVED] Gridline format
    By m@dvn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2005, 05:05 PM
  7. [SOLVED] Gridline Question
    By Wazza McG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2005, 08:05 AM

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