A guy from 1997 has the exact same question I do now... hopefully
someone can answer it (because he had no responses back then!)... I
am
gonna repost his question:

I am trying to plot a chart containing data similar to that shown
below, without much success:


Sprinkler OnTime OffTime
Front 0815 0845
Front 1445 1600
Front 1700 1730
Back 0900 0930
Back 1800 1830
Left 1100 1115
Right 1130 1215
Right 1900 1930
Right 2000 2030


I'd like to see a graph with four (discontinuous) horizontal lines,
each line corresponding to one of the sprinklers. The X axis is
plotted
from 0000 to 2400, and each line is visible when the sprinkler is on.

Hi,

See here for information on gantt charts.
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

The major task will be laying out the data correctly as the chart will
not summarize your data, instead you need to do that.

Cheers
Andy

Paul wrote:
A guy from 1997 has the exact same question I do now... hopefully
someone can answer it (because he had no responses back then!)... I
am
gonna repost his question:

I am trying to plot a chart containing data similar to that shown
below, without much success:


Sprinkler OnTime OffTime
Front 0815 0845
Front 1445 1600
Front 1700 1730
Back 0900 0930
Back 1800 1830
Left 1100 1115
Right 1130 1215
Right 1900 1930
Right 2000 2030


I'd like to see a graph with four (discontinuous) horizontal lines,
each line corresponding to one of the sprinklers. The X axis is
plotted
from 0000 to 2400, and each line is visible when the sprinkler is on.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Ok, so I kind of have it... follow-up question:

Say that Task one has three seperate time periods... Is there a simple
way to get all those on the same horizontal line instead of beneath
each other as seperate instances? Or is this a matter of organizing
the data?

Andy Pope wrote:
Hi,

See here for information on gantt charts.
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

The major task will be laying out the data correctly as the chart will
not summarize your data, instead you need to do that.

Cheers
Andy

Paul wrote:
A guy from 1997 has the exact same question I do now... hopefully
someone can answer it (because he had no responses back then!)... I
am
gonna repost his question:

I am trying to plot a chart containing data similar to that shown
below, without much success:


Sprinkler OnTime OffTime
Front 0815 0845
Front 1445 1600
Front 1700 1730
Back 0900 0930
Back 1800 1830
Left 1100 1115
Right 1130 1215
Right 1900 1930
Right 2000 2030


I'd like to see a graph with four (discontinuous) horizontal lines,
each line corresponding to one of the sprinklers. The X axis is
plotted
from 0000 to 2400, and each line is visible when the sprinkler is on.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

On Fri, 29 Feb 2008, in microsoft.public.excel.charting,
Paul said:

Say that Task one has three seperate time periods... Is there a simple
way to get all those on the same horizontal line instead of beneath
each other as seperate instances? Or is this a matter of organizing
the data?

This is how it needs to look:

Sprklr On1 Off1 On2 Off2 On3 Off3
Front 08:15 00:30 06:00 01:15 01:00 00:30
Back 09:00 00:30 08:30 00:30
Left 11:00 00:15
Right 11:30 00:45 06:45 00:30 00:30 00:30

Each period is the *difference* between two times, so you will use the
original data to subtract each time from the time just before it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.