+ Reply to Thread
Results 1 to 5 of 5

Manually adjust values on Y axis

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    Oslo, Norway
    MS-Off Ver
    2010/2017
    Posts
    20

    Manually adjust values on Y axis

    Hi,

    I am wondering if it is possible to let the Y-axis start on 0 on top of the orange bar. I know I can set a minimum point for the Y-axis, but then I lose the blue and orange bar.
    excelforum3.PNG

    Below 0 (on the side of the blue and orange bar, I don't want any numbers.
    Does anyone know how I can obtain this?

    Thanks in advance,
    maboho93
    Last edited by maboho93; 01-04-2018 at 04:13 AM.

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

    Re: Manually adjust values on Y axis

    Can you explain in more detail what you tried to set a minimum for the y-axis, because that is exactly what I would have expected to do:

    1) figure out the desired y-axis minimum that places 0 on top of the orange bar (in this case -18.2).
    2) Then, to hide the negative y axis labels, a number format code like "0;;0;@". Note that I left the negative number section of the format code empty to indicate that negative numbers should not be displayed. If you are unfamiliar with custom number formats: https://support.office.com/en-us/art...2-09fab54be7f4
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-02-2018
    Location
    Oslo, Norway
    MS-Off Ver
    2010/2017
    Posts
    20

    Re: Manually adjust values on Y axis

    Thank you for your help.

    When I tried adjusting the minimum value, I tried to adjust it to 18.2 (positive). That's the reason the bars disappeared.

    Now, I tried to set it to -18.2. The bars still start at 0. It seems like I cannot add custom number formats either. I read the page you suggested.

    Attached is a simplified example. Could you please try to assist me by editing the file?
    Attached Files Attached Files

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

    Re: Manually adjust values on Y axis

    I can't upload a file for you at the moment. After tinkering with it for a bit, here are the edits I made to your file that achieve what I think you want for this specific example:
    1) Enter -10 and -20 into B1 and B2.
    2) Enter -10 and -20 into B5:B11 and C5:C11.
    3) The auto limits on the axis selected by Excel seemed good, so I left them unchanged.
    4) Get into the Format axis dialog -> Number -> Custom -> Add "#,##0;;0" to the list and use that custom number format code.

    Is that closer to what you want?

  5. #5
    Registered User
    Join Date
    01-02-2018
    Location
    Oslo, Norway
    MS-Off Ver
    2010/2017
    Posts
    20

    Re: Manually adjust values on Y axis

    This is what I wanted. Thank you very much!

+ 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] Automatically Adjust Y-Axis Min and Max
    By sungen99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2017, 07:49 PM
  2. Chart Axis conversion manually
    By vjharry in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-11-2015, 05:21 PM
  3. How can I change the values of the y-axis manually
    By MichaelGSI in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-27-2015, 08:44 AM
  4. Replies: 2
    Last Post: 04-21-2014, 03:26 PM
  5. Manually adjust grouping in pivot table
    By Jonathan9 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-16-2013, 11:28 AM
  6. Replies: 1
    Last Post: 10-18-2005, 08:05 AM
  7. Manually Setting Date/Time Range of Axis
    By pittpanther in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-19-2005, 11:05 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