How would I make a graph out of this chart? (ms excel 07)

Discussion in 'The Guru's Pub' started by vvv123, Oct 3, 2010.

  1. vvv123

    vvv123 Master Guru

    Messages:
    347
    Likes Received:
    0
    GPU:
    XFX 7600GT XXX
    Hi, I am writing a lab paper for this lab we did at school and I have this chart with different ph's and time and I'm trying to create a line (or bar?) graph in excel but I just don't know how to make one with this much data. I know how to create simple line/bar graphs but this one is just not working....can someone help? any advice/input is appreciated thanks!!

    and I really didn't know which section to post this in so if this is the wrong section, then I'm sorry mods :nerd:

    [​IMG]
     
  2. Dustpuppy

    Dustpuppy Ancient Guru

    Messages:
    4,146
    Likes Received:
    0
    GPU:
    integrated - fffffffuuuuu
    put time & ph on the same row (a1 = time, B1 = ph etc)

    Select all of the data, then hit ALT N D in that order (not holding them down at once) select 'scatter with straight lines and markers' or just scatter.
     
  3. vvv123

    vvv123 Master Guru

    Messages:
    347
    Likes Received:
    0
    GPU:
    XFX 7600GT XXX
    OMGGGGGGGGGGGGG that worked!!!!!!!1 thanks!!!
     
  4. Dustpuppy

    Dustpuppy Ancient Guru

    Messages:
    4,146
    Likes Received:
    0
    GPU:
    integrated - fffffffuuuuu
    you're welcome :)
     

Share This Page