+ Reply to Thread
Results 1 to 5 of 5

Change Y Axis on graph

  1. #1
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Change Y Axis on graph

    Hi All, in the attached workbook I have some date and a graph. The vertical axis shows 0-25 upwards but what I want is that to show 1 at the top down to 24 at the bottom or better still 1st to 24th. I've been looking at videos on utube to try and work it out how to do it but when I click on the Y axis as instructed I do not get the option "Format Axis" which it shows. Many thanks.

    Note: The graph shows where a team was positioned in the league after each game played, hence why I want 1st at the top.
    Attached Files Attached Files
    Last edited by Marvo; 02-11-2024 at 08:18 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Change Y Axis on graph

    Is this what you're after? If you want 1 at teh top, it'll look odd, as the next axis markers will be 6,11,etc.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Change Y Axis on graph

    Very nearly Glenn. I've added a page to demonstrate what I'd really like.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Change Y Axis on graph

    Closer? Close enough??
    Attached Files Attached Files

  5. #5
    Forum Contributor Marvo's Avatar
    Join Date
    01-15-2009
    Location
    Northampton, England
    MS-Off Ver
    Excel 2021
    Posts
    990

    Re: Change Y Axis on graph

    That's great Glenn, Thank you so 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. Make a graph with a mechanism to change the Y-axis
    By randoreds in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-22-2017, 10:38 PM
  2. Unable to change graph axis titles.
    By SBE86 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-17-2016, 07:56 AM
  3. how to change the value of x -axis on the excel graph
    By killa in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-03-2013, 02:34 PM
  4. [SOLVED] How to change graph axis name automatically?
    By NameUse in forum Excel General
    Replies: 3
    Last Post: 11-19-2012, 04:42 PM
  5. How do I change x axis on a graph??
    By cicero0x in forum Excel General
    Replies: 1
    Last Post: 04-22-2009, 08:13 AM
  6. [SOLVED] how do i change the x-axis of a graph to a log scale?
    By anne in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-13-2006, 02:35 PM
  7. How do you change the values of a graph on the x-axis?
    By tman224 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-12-2005, 09: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