+ Reply to Thread
Results 1 to 3 of 3

2010 - Remove zero vertical axis line in 3-D column chart with positive & negative values

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    In front of a screen with numbers and lines
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    2

    2010 - Remove zero vertical axis line in 3-D column chart with positive & negative values

    I will get the obligatory "long time reader, first time poster" comment out now.

    Create a new Excel 2010 workbook. Create a small series of numbers, some negative, some positive, for example:

    Data Dater Dated
    Positive 15 34 11
    Negative -5 -39 -7

    Highlight data, insert column chart, 3-D clustered column.

    See that 50 shades of grey line horizontally across the middle? That is the vertical (value) axis line. I'd like to get rid of it. It rears its ugly head whenever the value of zero is not at the bottom of the vertical axis in your precious chart. 2007 has the same issue, yet in 2003 this is not a problem.

    "Aha" you say! Change chart type, 2-D column, high five!

    Nope, marketing type peoples like their charts in 3-D, TYVM.

    Oh ... format the vertical axis so that the floor crosses at the minimum major vertical axis value, boom!

    That's one fugly chart you've got there; since we have negative numbers and all, everything looks positive.

    Oh ... chart tools, Axes, Primary vertical axis, None. Problem solved!

    Not really, you just removed those vertical axis numbers, which we need.

    Oh ... create a text box of numbers along the left side, victory is mine!

    Possibly, but this gets linked to Powerpoint monthly and the numbers change enough to make it fairly difficult to people that just want to open it and press the fancy print button in the quick access toolbar since hiding it under File is too complex.

    I'm probably overlooking something very simple and missing it OR this has already been answered elsewhere. If so, I apologize. All I need is that grey line gone without changing anything else in the 3-D column chart.

    I invoke the power of the interwebs to assist. Interweb powers, activate!

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

    Re: 2010 - Remove zero vertical axis line in 3-D column chart with positive & negative val

    Select horizontal axis and set line style to None. Also set Axis labels to Low.

    If not post example file
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-30-2013
    Location
    In front of a screen with numbers and lines
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    2

    Re: 2010 - Remove zero vertical axis line in 3-D column chart with positive & negative val

    That would do it, thank you Andy!

+ 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. Chart Axis Scale Editing - Positive and Negative Independantly
    By BIGGIE9 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 12-11-2013, 02:27 PM
  2. Sparkline Horizontal Axis Values All Positive Or All Negative
    By goss in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-25-2013, 09:01 AM
  3. [SOLVED] Scaling positive and negative values on primary and secondary axis respectively
    By Lui23 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-23-2012, 10:47 AM
  4. Replies: 2
    Last Post: 06-18-2012, 04:26 PM
  5. Chart using one column as vertical axis and others on horizontal axis!!!
    By nandhamnk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-28-2007, 09:40 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