Need help on making line graphs in excel 2007

Discussion in 'Computer Games and General Discussion' started by webyugioh, Sep 2, 2008.

  1. webyugioh
    OP

    webyugioh GBAtemp Advanced Fan

    Member
    530
    0
    Sep 17, 2007
    10KM East of Nowhere
    I need help making a graph with this data

    Type of Production |A | B | C | D| E|
    Automobiles | 0 | 2 | 4 | 6 | 8|
    ForkLifts | 30 | 27 | 21 | 12 | 0|

    and it need it to look something like this
    [​IMG]
    (made this in MS paint)

    Every time I go into Excel 07, it won't let me put numbers on both axis.
    Can anybody help me?
    Thanks in advance!
     
  2. BiscuitBee

    BiscuitBee Semi-Resident Cookie-Bug

    Member
    689
    5
    Jul 30, 2008
    Canada
    Canada
    Try using a "Scatter" Graph.
     
  3. webyugioh
    OP

    webyugioh GBAtemp Advanced Fan

    Member
    530
    0
    Sep 17, 2007
    10KM East of Nowhere
    OH, THANK YOU SO MUCH!!!!!!!!
    I am in you debt.
     
  4. BiscuitBee

    BiscuitBee Semi-Resident Cookie-Bug

    Member
    689
    5
    Jul 30, 2008
    Canada
    Canada
    No problem [​IMG]