Make Y-axis values correspond to x- axis value

Discussion in 'Excel Charting' started by Tonso, Mar 26, 2014.

  1. Tonso

    Tonso Guest

    (x) (y)
    Group Minutes
    -2 1.79
    -1 7.61
    0 26.45
    1 28.9
    2 17.18
    3 27.8
    4 26.1
    5 26.7
    6 25.8
    7 21.8
    8 17.4
    9 0
    10 33.69
    11 0
    12 0
    13 0
    14 14.8
    15 0
    16 0
    17 17.18
    18 0
    19 0
    20 20.48
    I want to make a column graph(or bar), with the "Group" numbers being on the x-axis, and the "Minutes" being the y-axis value, so that "-2" is an x-axis value, and the above it is the bar representing 1.79, then the next value on the x-axis will be "-1", and above it will be a bar representing 7.61,and so on. It seems simple enough, but i am unable to accomplish this. What must I do?

    Thanks,

    Tonso
     
    Tonso, Mar 26, 2014
    #1
    1. Advertisements

  2. Tonso

    Guest

    Hi Tonso,

    Am Mittwoch, 26. März 2014 22:10:44 UTC+1 schrieb Tonso:

    > I want to make a column graph(or bar), with the "Group" numbers being on the x-axis, and the "Minutes" being the y-axis value, so that "-2" is an x-axis value, and the above it is the bar representing 1.79, then the next value on the x-axis will be "-1", and above it will be a bar representing 7.61, and so on. It seems simple enough, but i am unable to accomplish this. What must I do?


    select your Chart => Chart Tools => Select Data => Horizontal Axis Labels => Edit and Change the Axis Label Range to your expected range.
    You can look here:
    https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
    for the workbook "Chart_T"

    Regards
    Claus
     
    , Mar 27, 2014
    #2
    1. Advertisements

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Eva Whitley
    Replies:
    2
    Views:
    148
    Eva Whitley
    Apr 29, 2004
  2. David
    Replies:
    1
    Views:
    133
    Debra Dalgleish
    May 4, 2004
  3. TryingToExcel
    Replies:
    1
    Views:
    194
    Tushar Mehta
    Feb 18, 2005
  4. vp23larry
    Replies:
    2
    Views:
    309
    Collins32
    Jun 23, 2005
  5. soconfused

    How do make a line correspond to date

    soconfused, May 22, 2007, in forum: Excel Charting
    Replies:
    7
    Views:
    182
    Jon Peltier
    May 24, 2007
  6. Aaron
    Replies:
    1
    Views:
    264
    Del Cotter
    Aug 17, 2007
  7. -markc
    Replies:
    2
    Views:
    217
    -markc
    Oct 31, 2007
  8. darrel
    Replies:
    1
    Views:
    322
    Tobi Ackerman
    Jan 22, 2011
Loading...