Floating Bars

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

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

"Songoku" wrote:

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

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

"bj" wrote:

> I don't understand the "get duplicate chutes" comment. More info, please?
>
> "Songoku" wrote:
>
> > 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!!!!

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.


"Songoku" wrote:

> 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.....
>
> "bj" wrote:
>
> > I don't understand the "get duplicate chutes" comment. More info, please?
> >
> > "Songoku" wrote:
> >
> > > 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!!!!

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/
_______

Songoku wrote:
> 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.....
>
> "bj" wrote:
>
>
>>I don't understand the "get duplicate chutes" comment. More info, please?
>>
>>"Songoku" wrote:
>>
>>
>>>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!!!!

Thanks for the reponse but i am not sure I follow, do you mean i should get
the data be on 1 line?
i.e
Chute open time duration open time duration open time duration
01B 05:00 00:30 08:00 00:45 09:00 1:15

please can u elaborate.....

"bj" wrote:

> 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.
>
>
> "Songoku" wrote:
>
> > 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.....
> >
> > "bj" wrote:
> >
> > > I don't understand the "get duplicate chutes" comment. More info, please?
> > >
> > > "Songoku" wrote:
> > >
> > > > 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!!!!

apologies Jon but I don't follow my first duation is 0?

"Jon Peltier" wrote:

> 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/
> _______
>
> Songoku wrote:
> > 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.....
> >
> > "bj" wrote:
> >
> >
> >>I don't understand the "get duplicate chutes" comment. More info, please?
> >>
> >>"Songoku" wrote:
> >>
> >>
> >>>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!!!!
>

it will need to be set up like a stacked bar chart including not used times

for example
Chute open time duration open time duration open time duration
01B 05:00 00:30 08:00 00:45 09:00 1:15

the data would be
A B C D E
F
01B 5 .5 2.5 .75 .25
1.25

when you plot it as stacked bar: if you select none for the A, C and E
catagories it will show the hours open on one line.

"Songoku" wrote:

> Thanks for the reponse but i am not sure I follow, do you mean i should get
> the data be on 1 line?
> i.e
> Chute open time duration open time duration open time duration
> 01B 05:00 00:30 08:00 00:45 09:00 1:15
>
> please can u elaborate.....
>
> "bj" wrote:
>
> > 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.
> >
> >
> > "Songoku" wrote:
> >
> > > 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.....
> > >
> > > "bj" wrote:
> > >
> > > > I don't understand the "get duplicate chutes" comment. More info, please?
> > > >
> > > > "Songoku" wrote:
> > > >
> > > > > 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!!!!

If I understand your table:

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

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/
_______


Songoku wrote:

> apologies Jon but I don't follow my first duation is 0?
>
> "Jon Peltier" wrote:
>
>
>>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/
>>_______
>>
>>Songoku wrote:
>>
>>>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.....
>>>
>>>"bj" wrote:
>>>
>>>
>>>
>>>>I don't understand the "get duplicate chutes" comment. More info, please?
>>>>
>>>>"Songoku" wrote:
>>>>
>>>>
>>>>
>>>>>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!!!!
>>