![]() |
How to put cell data in chart y-axis?
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!! |
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!! |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com