charting on/off status

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

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
 
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
 
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
 
Back
Top