| 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 |
| 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) | |||
Threaded Mode
