charting on/off status

I need to chart the on or off status of a device. I would
like for the chart to show a "1" on the y-axis when the
device is on and a "0" on the y-axis when the device is
off. The x-axis would show the time.

If the device comes on at 9:00 am my data recorder records
a record with a value of "1" at 9:00. Data recorder's
next record is a "0" at 9:23 when the device changes to
the off state.

Can someone help me to chart this type of information? In
the end, I have 4 data recorders that I want to plot on
the same chart to determine when the devices are running
at the same time.

thanks,
Greg

This may be over simplified but I have attached a file that will get you
started on your device comparison. In a nutshell all you need to do is
key in the actual time you need and the "1" or "0" associatied with
each time for each device. When all four bars appear together or don't
appear at all, your devices are in sync...

Attachment filename: device.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=434425
---
Message posted from http://www.ExcelForum.com/

Thanks for the file. What I think I am trying to do is to
create a bar chart where the width of the bar corresponds
to the lenth of time that the device was on. For
instance, if the device came on at 8:26 and went off at
8:32 then I would like to see a bar for the event that had
a y-axis value of 1 and an x-axis value of 6 minutes. Not
all of the device will have equal run-times or "bar
widths". I would post my file so that you could see the
data but I'm not sure how to do it.

Any help you can provide is greatly appreciated.
Thanks,

Greg
>-----Original Message-----
>This may be over simplified but I have attached a file
that will get you
>started on your device comparison. In a nutshell all you
need to do is
>key in the actual time you need and the "1" or "0"
associatied with
>each time for each device. When all four bars appear
together or don't
>appear at all, your devices are in sync...
>
> Attachment filename:
device.xls
>Download attachment:
http://www.excelforum.com/attachment.php?postid=434425
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

Check the Excel/Charts/'Step chart' page of my web site. To plot
multiple devices on the same page, I would plot device one in the 0-1
range, device 2 in the 2-3 range, and so on.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <b5aa01c3ed18$bb648170$a101280a@phx.gbl>,
crowleyoyo@yahoo.com says...
> I need to chart the on or off status of a device. I would
> like for the chart to show a "1" on the y-axis when the
> device is on and a "0" on the y-axis when the device is
> off. The x-axis would show the time.
>
> If the device comes on at 9:00 am my data recorder records
> a record with a value of "1" at 9:00. Data recorder's
> next record is a "0" at 9:23 when the device changes to
> the off state.
>
> Can someone help me to chart this type of information? In
> the end, I have 4 data recorders that I want to plot on
> the same chart to determine when the devices are running
> at the same time.
>
> thanks,
> Greg
>