+ Reply to Thread
Results 1 to 2 of 2

How to format the horizontal zero gridline-Office 365

  1. #1
    Forum Contributor
    Join Date
    08-05-2009
    Location
    Colorado Springs, CO
    MS-Off Ver
    Office 365
    Posts
    160

    How to format the horizontal zero gridline-Office 365

    When I format a chart to have horizontal grid lines, set color and thickness, no gridline appears at zero on the y-axis. I want to set default charts so that the gridline at value zero will appear the same as the others.

    Zero Gridline.PNG


    Here's how:
    1. Right click the gridline you want to format
    2. Select format axis
    3. Click on the bucket symbol (fill and line)
    4. Select the color and thickness
    5. Close format dialog

    This seems like a bug to me.
    Last edited by Atom; 12-08-2018 at 03:22 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to format the horizontal zero gridline-Office 365

    It's not a gridline at zero it's the primary horizontal axis. Just format it with the same characteristics you've used for the gridlines.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Formatting a single horizontal gridline on a graph
    By brdmartin in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-07-2015, 05:55 PM
  2. [SOLVED] Change data from vertical format to horizontal format
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2013, 07:06 PM
  3. Is it possible to format an individual gridline?
    By Doctor Wu in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-06-2012, 04:16 PM
  4. [SOLVED] does horizontal scroll work with office 2007?
    By obidon in forum Excel General
    Replies: 1
    Last Post: 07-31-2006, 09:38 AM
  5. [SOLVED] Gridline format
    By m@dvn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2005, 05:05 PM
  6. [SOLVED] How to format an isolated value and gridline on my graph?
    By Duncan Landreth in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-29-2005, 12:05 PM
  7. Format Gridline (BOLDING) and Changing Axis Labels
    By hokieguy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2005, 04:35 PM

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