Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
time plots/charts in Excel
I am trying to plot usage time for a device we use; data is in the following
format: A B C Online 23:27:39 12-Oct-08 Online 23:30:54 12-Oct-08 Online 23:34:09 12-Oct-08 Online 23:37:24 12-Oct-08 Offline 23:40:37 12-Oct-08 Offline 23:43:50 12-Oct-08 Offline 23:47:03 12-Oct-08 Offline 12:00:28 13-Oct-08 Offline 12:03:41 13-Oct-08 Offline 12:06:54 13-Oct-08 Online 12:10:10 13-Oct-08 Online 12:13:26 13-Oct-08 Online 12:16:42 13-Oct-08 Online 12:19:58 13-Oct-08 Offline 12:23:11 13-Oct-08 Offline 12:26:24 13-Oct-08 Offline 12:29:37 13-Oct-08 Offline 14:51:13 13-Oct-08 Offline 14:54:26 13-Oct-08 I'm trying with no success to plot online time by day and by time windows, on a 24 hour scale. Help and tips will be much appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you create Box Plots (Box-and-Whisker Plots) in Excel? | Charts and Charting in Excel | |||
How can I create stem and leaf charts / box plots? | Charts and Charting in Excel | |||
Can time be used as both the x and y variables in scatter plots? | Charts and Charting in Excel | |||
Excel gives me line plots - I want scatter plots | Charts and Charting in Excel | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel |