+ Reply to Thread
Results 1 to 2 of 2

Change of Category (X) axis labels

  1. #1
    Registered User
    Join Date
    03-18-2008
    Posts
    1

    Change of Category (X) axis labels

    Hi, I would like to ask you for help with change of (X) axis labels in my graph. I have those source data:

    ot1 = (question n. 1)
    a 0
    b 0
    c 4
    d 0

    created graph you can see as a picture.

    Now, I would like to change 'a', 'b', 'c' and 'd' to some text (answers) like 'Yes', 'No', 'Not sure' .... etc, but source data must stay as you see. The problem is that answers are not same for all questions...

    regards
    Patrik
    Attached Images Attached Images

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    Hi Patrik,

    Welcome to the forum!

    Does this help, add an extra column with the data labels and refer to those.
    Attached Files Attached Files
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

+ Reply to Thread

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.6.0 RC 1