+ Reply to Thread
Results 1 to 4 of 4

Y-axis not formatting correctly

  1. #1
    Registered User
    Join Date
    06-25-2017
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    2

    Y-axis not formatting correctly

    Hi,

    I am trying to create this simple bar chart (see attached) but I cannot get the y-axis to format correctly so that the bars in the graph are not completely flat. Please help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Y-axis not formatting correctly

    your data is formatted in TEXT (note the green triangle in the top left hand corner)
    change them all to percentage and you should get them to work properly
    note that would mean your axis numbers you have forced in will need to be changed also

    on attached file
    i set them too to auto except minimum which is set to 0
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-25-2017
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Microsoft Excel for Mac 2011
    Posts
    2

    Re: Y-axis not formatting correctly

    Thank you so much, this is brilliant!!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Y-axis not formatting correctly

    Not a problem, glad to help

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Date not showing correctly on X Axis.
    By buffnuff in forum Excel General
    Replies: 4
    Last Post: 01-09-2017, 02:01 PM
  2. X-axis not reflecting data correctly
    By MC7410 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2013, 05:45 PM
  3. [SOLVED] Dates not showing correctly on x-axis
    By wes675 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2013, 05:55 PM
  4. Graph - correctly linking to X axis?
    By MattKneale in forum Excel General
    Replies: 2
    Last Post: 12-05-2010, 11:14 AM
  5. Chart x-axis not plotting dates correctly
    By cmyers in forum Excel General
    Replies: 3
    Last Post: 11-10-2010, 02:31 PM
  6. x axis on chart can't be adjusted correctly
    By mufan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-18-2010, 10:29 AM
  7. How to correctly scale X-Axis in Charts?
    By Peter Bernadyne in forum Excel General
    Replies: 3
    Last Post: 12-20-2005, 05:47 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