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

    Member webyugioh GBAtemp Advanced Fan

    Joined:
    Sep 17, 2007
    Messages:
    530
    Location:
    10KM East of Nowhere
    Country:
    Japan
    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

    Member BiscuitBee Semi-Resident Cookie-Bug

    Joined:
    Jul 30, 2008
    Messages:
    689
    Location:
    Canada
    Country:
    Canada
    Try using a "Scatter" Graph.
     
  3. webyugioh
    OP

    Member webyugioh GBAtemp Advanced Fan

    Joined:
    Sep 17, 2007
    Messages:
    530
    Location:
    10KM East of Nowhere
    Country:
    Japan
    OH, THANK YOU SO MUCH!!!!!!!!
    I am in you debt.
     
  4. BiscuitBee

    Member BiscuitBee Semi-Resident Cookie-Bug

    Joined:
    Jul 30, 2008
    Messages:
    689
    Location:
    Canada
    Country:
    Canada
    No problem [​IMG]
     

Share This Page