If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
charting on/off status
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/ . |
Thread Tools | |
Display Modes | |
|
|