transfering data from a table to a line graph

[batyeshua]

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!

 

[Jon Peltier]

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
_______