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
|
|||
|
|||
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!!!! |
#2
|
|||
|
|||
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!!!! |
#3
|
|||
|
|||
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!!!! |
#4
|
|||
|
|||
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!!!! |
#5
|
|||
|
|||
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!!!! |
#6
|
|||
|
|||
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!!!! |
#7
|
|||
|
|||
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!!!! |
#8
|
|||
|
|||
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!!!! |
#9
|
|||
|
|||
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!!!! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
floating bars graph | rjb | Powerpoint | 1 | April 4th, 2005 08:37 PM |
Floating Bars | Michael beuhler | Charts and Charting | 3 | March 8th, 2004 08:22 AM |