Step 6 - Planet Discovery Spreadsheet - Second Graph

     Now it is time to make your 2nd Graph.  Follow the instructions for the graph you just made if you need help with each individual step.  Below are the instructions for making a Line Graph.   

Graph 2 - My Age on Each Planet Line Graph

1. This will show a Line Graph of your age on each planet!  You will create this graph on your own.  You will need to highlight cells A2– A10, hold down the Ctrl Key, then highlight cells I2 – I10.  Now click on INSERT, then CHART.  This will automatically create a Column Graph. 
2. On the right side of your screen on the CHART EDITOR, change Chart Type to LINE CHART.
3. Double Click on the title of your graph.  Change the title to My Age On Each Planet.
4. Double click the line of your graph.  On the right hand side in the CHART EDITOR, select Data Labels to put numbers on your line.  
5. Drag your My Age on Each Planet Line Chart underneath your My Weight On Each Planet COLUMN CHART.  Feel free to change the colors and edit the graph however you like! Do you know how to change the background color of your graph?  Try it!
6. Which Planet did you weight the most on?  Which Planet did you weight the least?  Why do you weigh differently on each planet?

Example:  Your Line Chart should look like the example below!