If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
transfering data from a table to a line graph
Hey,
I thought I remembered how to plot these things, but obviously not. Basically, I need to plot a rate (y-axis) against concentration (x-axis) graph for a piece of Biology coursework. I've tried everything I can remember and I can't even get the scale correct. Please help me - my deadline is fast approaching! These are my results: Concentration Rate 5 cm3 0.16 cm3/s 10 cm3 0.33 cm3/s 15 cm3 0.91 cm3/s 20 cm3 2.11 cm3/s 25 cm3 2.99 cm3/s Many Thanks! |
#2
|
|||
|
|||
transfering data from a table to a line graph
You need to plot values. If you type "5 cm3" in a cell, you are entering
text, so the value in the chart will look like zero. Enter just the numbers in the cells, then select the data and create a chart. You're a scientist, so you'll do better with an XY chart. Choose the option that connects points with a line if you prefer. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "batyeshua" wrote in message ... Hey, I thought I remembered how to plot these things, but obviously not. Basically, I need to plot a rate (y-axis) against concentration (x-axis) graph for a piece of Biology coursework. I've tried everything I can remember and I can't even get the scale correct. Please help me - my deadline is fast approaching! These are my results: Concentration Rate 5 cm3 0.16 cm3/s 10 cm3 0.33 cm3/s 15 cm3 0.91 cm3/s 20 cm3 2.11 cm3/s 25 cm3 2.99 cm3/s Many Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Can I link 1 form to several tables? | Mico | Using Forms | 7 | July 6th, 2005 07:36 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
double window envelope | tpdebronsky | Page Layout | 4 | May 17th, 2005 07:34 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |