ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to put cell data in chart y-axis? (https://www.excelbanter.com/charts-charting-excel/205375-how-put-cell-data-chart-y-axis.html)

Omn1dex

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

Andy Pope

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