A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

charting on/off status



 
 
Thread Tools Display Modes
  #1  
Old February 7th, 2004, 02:21 AM
Greg
external usenet poster
 
Posts: n/a
Default 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  
Old February 7th, 2004, 04:59 AM
Greg
external usenet poster
 
Posts: n/a
Default 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/

.

  #3  
Old February 7th, 2004, 03:07 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default charting on/off status

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 ,
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.