+ Reply to Thread
Results 1 to 11 of 11

Make the Zero line bold

  1. #1
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Make the Zero line bold

    Hi all,

    Is it possible to make the 0% line bold on a line graph?

    So I have a graph of % difference - some are positive and some negative and I want to accentuate the 0% line in the middle?

    Any ideas?

    Thanks
    Matthew

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Make the Zero line bold

    Assume the axis is on the 0% point you could increase the weight of the axis
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Make the Zero line bold

    but that increases the weight of all the lines? I just want to increase the 0% line only... it doesn't always fall exactly on the x-axis. Thanks

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Make the Zero line bold

    It would help if you posted workbook example of such.

    If you can not use the axis then plotting data series is another alternative.

  5. #5
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Make the Zero line bold

    thanks , now attached example
    Attached Files Attached Files

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Make the Zero line bold

    2 examples included.

    First uses the horizontal axis

    Second uses additional data series on secondary axis.
    Secondary horizontal axis is unformatted so you can see it. Remove tick marks, ticklabels amd line.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Make the Zero line bold

    Thanks. I was aware of option two but would like to use option 1. However, how do you do this? On your examples, I appear to be able to select the horizontal category axis and format it (so quite easy) but on my graph I cannot select the horizontal axis alone?

    Thanks again

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: Make the Zero line bold

    That's because you original chart has no horizontal axis applied.

    select the chart and use Chart Tools > Layout > Axes > Primary Horizontal Axis > Show Left to Right.

    The format the axis to have thick coloured line style.
    set Tick mark and tick labels to none.

  9. #9
    Registered User
    Join Date
    11-30-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    58

    Re: Make the Zero line bold

    Thanks so much

  10. #10
    Registered User
    Join Date
    09-08-2017
    Location
    St. Louis
    MS-Off Ver
    2007
    Posts
    1

    Re: Make the Zero line bold

    Andy Pope
    Re: Make the Zero line bold
    2 examples included.

    Both examples show what I want to do, i.e., make the Zero line bold, but there are no instructions for how to do it.

  11. #11
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Make the Zero line bold

    Allanx,
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Ben Van Johnson

+ 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. [SOLVED] how do i make certain words bold?
    By pablowilks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 02:48 PM
  2. how can I make this BOLD?
    By Mamud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-22-2012, 06:15 AM
  3. Part of line in a Graph/Chart bold?
    By peter233 in forum Excel General
    Replies: 1
    Last Post: 05-22-2008, 05:16 AM
  4. Make string bold?
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2005, 11:07 AM
  5. How do I make this string bold?
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2005, 11:06 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