Floating Bars

[Guest]

Hi,

I need to create a floating bar graph to show when chutes open and their
durations so for example:

Chute Open Time Duration
01B 05:00 2:20
01B 07:20 2:20
01B 08:00 0:40

problem I am having is that when i go to create the floating bar graph
although the general information is correct i.e time and duration i get
duplicate chutes. I have tried converting these to numbers but have had no
joy..........

any help please.........would be appreciated!!!!

 

[Guest]

I don't understand the "get duplicate chutes" comment. More info, please?

 

[Guest]

for example

where the graph should display

01B ******** ****** ******
05:00 05:30 06:00 06:30 07:00 07:30 08:00

I get

01B *****

01B *******

01B **********
05:00 05:30 06:00 06:30 07:00 07:30 08:00

I have tried to convert the chute to number however I get the same thing.....

 

[Guest]

The way you have your data set up it thinks there are three different rows
you want to print
you will need to set up your data such that each chute is a different
catagory and your start stop times are different data sets to get them all on
the same line.

 

[Jon Peltier]

You need all of the data in a single row. Only the first time is
absolute, the rest are durations, so you're plotting 'Start', 'Duration
Open', 'Duration Closed', 'Duration Open', etc.

I was going to reconfigure the data as an illustration, but your first
'Duration Closed' is zero, and the second is negative (open comes before
previous close).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

If I understand your table:

Open time 5:00 plus (open) duration 2:20 is 7:20, which is the next open
time, so there's no closed duration. Open time 7:20 plus (open) duration
2:20 is 9:40, which comes after the next open time of 8:00.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______