Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |