Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY graph to show date and time
Can anyone tell me how to create an xy scatter graph, so I can have the date
on the x axis the time on the y axis (hourly between 0600 and 2200) and the different data displayed. I can not get it to work. The data is displayed, but the axis information is wrong, date and time. below is the data i have, but will contain data for the whole week. Thanks Andy Date Trailer Refused Trailer Requested Trailer Delivered 07/11/2006 07/11/2006 07/11/2006 07/11/2006 6:00:00 7:30:00 07/11/2006 8:30:00 07/11/2006 10:00:00 07/11/2006 10:10:00 07/11/2006 12:30:00 08/11/2006 7:45:00 9:00:00 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY graph to show date and time
I made a Line chart of this data that seems OK
Had to format the y-axis as Time Try this and then tell us more specifically what goes wrong -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ingalla" wrote in message ... Can anyone tell me how to create an xy scatter graph, so I can have the date on the x axis the time on the y axis (hourly between 0600 and 2200) and the different data displayed. I can not get it to work. The data is displayed, but the axis information is wrong, date and time. below is the data i have, but will contain data for the whole week. Thanks Andy Date Trailer Refused Trailer Requested Trailer Delivered 07/11/2006 07/11/2006 07/11/2006 07/11/2006 6:00:00 7:30:00 07/11/2006 8:30:00 07/11/2006 10:00:00 07/11/2006 10:10:00 07/11/2006 12:30:00 08/11/2006 7:45:00 9:00:00 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY graph to show date and time
Put the dates in one column and the times in the next column.
If you've got data which is date & time together in Excel's format you may need to split them =INT(A1) will give date and =MOD(A1,1) will give time. Select the two columns, and Insert/ Chart. If you are getting a wrong result, you may need to tell us what result you are getting. -- David Biddulph "ingalla" wrote in message ... Can anyone tell me how to create an xy scatter graph, so I can have the date on the x axis the time on the y axis (hourly between 0600 and 2200) and the different data displayed. I can not get it to work. The data is displayed, but the axis information is wrong, date and time. below is the data i have, but will contain data for the whole week. Thanks Andy Date Trailer Refused Trailer Requested Trailer Delivered 07/11/2006 07/11/2006 07/11/2006 07/11/2006 6:00:00 7:30:00 07/11/2006 8:30:00 07/11/2006 10:00:00 07/11/2006 10:10:00 07/11/2006 12:30:00 08/11/2006 7:45:00 9:00:00 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY graph to show date and time
On Tue, 7 Nov 2006, in microsoft.public.excel.charting,
ingalla said: Can anyone tell me how to create an xy scatter graph, so I can have the date on the x axis the time on the y axis (hourly between 0600 and 2200) and the different data displayed. I can not get it to work. Andy, the most important bit is to take the word "Date" out of the cell that it's currently in. It's an annoying feature of Excel that it tries to guess which is the x-axis and series labels by looking to see what cells in the upper left are empty, but Microsoft never tell the user that, they just assume you're telepathic. Date Trailer Refused Trailer Requested Trailer Delivered Do that and you should be 90% of the way to your goal. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Date & Time Custom Cell - Need to show blank! | Excel Discussion (Misc queries) | |||
How to show current date and time | New Users to Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How do I format column containing date and time to only show the . | Excel Discussion (Misc queries) |