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:
    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=9378AAB6121822A3&id=9378AAB6121822A3%21326#cid=9378AAB6121822A3&id=9378AAB6121822A3%21326
    for the workbook "Chart_T"

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

Ask a Question

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.