| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manually switch data from x axis to y axis in line chart? | Charts and Charting in Excel | |||
| chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
| How do i get my data to be on the x axis of a chart? | Charts and Charting in Excel | |||
| In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
| Format chart axis by inputting data in a cell | Charts and Charting in Excel | |||
Hybrid Mode
