Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta
    • 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!
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: March 7, 2013
Poll
Do you like carrot cake?

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

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