+ Reply to Thread
Results 1 to 5 of 5

How to change "Y' Axis Data Label.

Hybrid View

  1. 03-15-2015, 12:19 PM #1
    redwarez
    redwarez is offline
    Registered User
    Join Date
    03-13-2015
    Location
    UAE
    MS-Off Ver
    2019
    Posts
    33

    Smile How to change "Y' Axis Data Label.

    Dear All,

    Please help me how to change the "Y" Axis Data label for the attached chart as mentioned below.

    Instead of 20% - March'15
    40% - April'15
    60% - May'15
    80% - June'15
    100% - Total Target

    Capture.JPG

    Rgds

    Red.
    Reply With QuoteRegister To Reply
  2. 03-15-2015, 12:36 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to change "Y' Axis Data Label.

    We can't adjust a screenshot!! Please attach the Excel file.
    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
    Reply With QuoteRegister To Reply
  3. 03-15-2015, 01:10 PM #3
    redwarez
    redwarez is offline
    Registered User
    Join Date
    03-13-2015
    Location
    UAE
    MS-Off Ver
    2019
    Posts
    33

    Re: How to change "Y' Axis Data Label.

    Sorry sheet has been attached.

    Book.xls
    Reply With QuoteRegister To Reply
  4. 03-15-2015, 12:50 PM #4
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,345

    Re: How to change "Y' Axis Data Label.

    This technique (http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html ) is useful for this sort of thing.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  5. 03-16-2015, 11:18 AM #5
    redwarez
    redwarez is offline
    Registered User
    Join Date
    03-13-2015
    Location
    UAE
    MS-Off Ver
    2019
    Posts
    33

    Re: How to change "Y' Axis Data Label.

    Anybody help me.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cannot change axis label format
    By MiningCam in forum Excel General
    Replies: 1
    Last Post: 11-16-2014, 11:28 PM
  2. Super simple question: How to change label on x axis
    By kyles123 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-19-2013, 12:19 PM
  3. [SOLVED] how do I change the size of the y-axis label?
    By Alex in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2013, 09:43 AM
  4. Excel 2007 : Change color of particular category label on axis
    By jrtmouse in forum Excel General
    Replies: 1
    Last Post: 03-17-2011, 05:24 AM
  5. Truncated "y" axis label in chart
    By flakkortin in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-04-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1