View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default How to put cell data in chart y-axis?

Hi,

If you add a column header to your Time column you will help excel to guess
your data layout.
It expects the first column to be Category or X values. The second column to
be Y Values.


<blank Time
3 00:00
5 01:00
6 02:00
9 03:00


By the way shouting and telling those offering free help to hurry is a great
way to get a speedy answer, not!

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Omn1dex" wrote in message
...
I am having serious trouble with my excel system! I have 1 column for time,
another for temperature, I need time to be on the y-axis and Temp as a
line
on the graph. Damn auto-grapher creates a graph with both time and temp as
lines in the graph. PLZ HELP!!!11

P.S Hurry and answer this i have only today to do this!!