Use text descriptors as Y axis units

Discussion in 'Excel Charting' started by Tom Robinson, Jan 4, 2013.

  1. Tom Robinson

    Tom Robinson Guest

    Hi there!

    I use a set of text labels (22 of them) starting from 'A' and endin
    with 'V' that are equivalent to a numerical value where A=0, B=1, C=2..
    and V=21.

    I really want to have these text descriptors as my Y axis values an
    seeing as they are equally spaced, I would have thought there was a wa
    to do it.

    A typical graph I would need plotting would be a stacked graph whereb
    the X axis is a series of objects (i.e. cities, people's names etc.) an
    the Y axis is the series above, with the bars being comprised of a
    initial Y value plus a smaller value that 'sits on top'.

    Is this at all possible?

    Many thanks in advance!

    P.S. I have looked at PeltierTech's Arbitrary Axis webpage but
    couldn't seem to get that to work.

    To


    --
    Tom Robinson
     
    Tom Robinson, Jan 4, 2013
    #1
    1. Advertisements

  2. Tom Robinson

    Steve=True Guest

    Hi Tom,

    Check this out. I think it might work for you:

    'How-to Make Categories for Vertical and Horizontal Axis in an Exce
    Chart
    ' (http://www.exceldashboardtemplates.com/?p=1697)

    Let me know if it helps.

    Steve=Tru


    --
    Steve=True
     
    Steve=True, Jan 25, 2013
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. NTE

    Y axis, need varying units

    NTE, Dec 10, 2004, in forum: Excel Charting
    Replies:
    10
    Views:
    103
    Jon Peltier
    Dec 13, 2004
  2. Peter Carr

    Problem with date base units for x axis

    Peter Carr, Dec 15, 2004, in forum: Excel Charting
    Replies:
    1
    Views:
    74
    Andy Pope
    Dec 15, 2004
  3. vp23larry
    Replies:
    2
    Views:
    283
    Collins32
    Jun 23, 2005
  4. Nick Turner

    defining major units on chart axis

    Nick Turner, Aug 31, 2005, in forum: Excel Charting
    Replies:
    2
    Views:
    103
    Jon Peltier
    Aug 31, 2005
  5. JohanD
    Replies:
    3
    Views:
    556
    Jon Peltier
    Mar 19, 2006
  6. Nicocala
    Replies:
    1
    Views:
    73
    Kelly O'Day
    Apr 1, 2006
  7. Aaron
    Replies:
    1
    Views:
    231
    Del Cotter
    Aug 17, 2007
  8. darrel
    Replies:
    1
    Views:
    288
    Tobi Ackerman
    Jan 22, 2011
Loading...