How to put cell data in chart y-axis?

O

Omn1dex

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!!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Line Chart - Problems with labeling X-Axis 3
Graphs: 2 Lines on secondary Y-axis? 1
Y axis data point alignment with x axis dates 0
Time on Y-Axis 3
reverse axis not working as before... 0
How do I specify X,Y axis and Series values in a line graph? 5

Top