Join TSR now and get all your revision questions answeredSign up now
    • Thread Starter
    Offline

    0
    ReputationRep:
    Hi does anyone know how to put a huge amount of data like say 30 pieces of prices of in to a graph (any type) in exel just i need this for tomorrow so can anyone help asap
    Offline

    1
    ReputationRep:
    (Original post by jk97)
    Hi does anyone know how to put a huge amount of data like say 30 pieces of prices of in to a graph (any type) in exel just i need this for tomorrow so can anyone help asap
    Copy it all into normal cells on Excel, and then if you need two different axis etc, order the data into two different columns, and then highlight it all and click insert (at the top) and then the type of graph you want. If you don't get the result you want then play around with it a bit (positioning data in different cells etc) until you do. And make sure to edit the name of each axis to so you have a proper graph. For that just click the preset ones and edit or insert a new text box. Hope this helps!
    • Thread Starter
    Offline

    0
    ReputationRep:
    (Original post by Danya1)
    Copy it all into normal cells on Excel, and then if you need two different axis etc, order the data into two different columns, and then highlight it all and click insert (at the top) and then the type of graph you want. If you don't get the result you want then play around with it a bit (positioning data in different cells etc) until you do. And make sure to edit the name of each axis to so you have a proper graph. For that just click the preset ones and edit or insert a new text box. Hope this helps!
    thanks mate helped a tone!
 
 
 
Poll
Which pet is the best?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Quick reply
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.