Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
batyeshua
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting a new line in spreadsheet Rental Man Excel Discussion (Misc queries) 2 January 9th 06 04:55 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Help making a chart that doesn't graph cells without data? Filtration Guy Excel Discussion (Misc queries) 0 March 22nd 05 09:21 PM
How can deleted data reappear in a refreshed pivot table in Excel excel_user123456 Excel Discussion (Misc queries) 3 February 23rd 05 08:34 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"