+ Reply to Thread
Results 1 to 5 of 5
  1. #1
    Registered User
    Join Date
    07-04-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    16

    Problem with axis in chart

    Hi. I have a problem in labeling my vertical axis from just 1, 2, 3, 4, 5, 6 to what I intended which is eg EL, VZ, LK, SC, GN, SK.

    I apologize if this question has been posted but I can't seems to find any relevant solution..

    Appreciate any help attached is my excel.

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,924

    Re: Problem with axis in chart

    You are setting the Name of the series to

    ='MTD - Aug''09'!$K$17:$P$17

    instead of the Category labels.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-04-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    16

    Re: Problem with axis in chart

    but 'MTD - Aug''09'!$K$17:$P$17' is the cells with the data I wish to appear on the axis..

    Isn't it correct?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,924

    Re: Problem with axis in chart

    Surely your data is in row 18?
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    07-04-2009
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    16

    Talking Re: Problem with axis in chart

    Ohhh Thanks Andy! I get what you mean.

Thread Information

Users Browsing this Thread

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

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.2.0