Dynamic formula to show the day and the number of cycles that can be ran that day

[Woodchuck76]

I am making a horizontal bar graph for production scheduling and need it to be dynamic. For example, depending on the products I run, they could have between 5 and 15 cycles for the day, so if I choose say product 1 and it can do 5 cycles in one day, then the array that feeds the graph will populate with 5 rows, and will look up the runtimes for product 1. The formula would then need to look at day 2, and populate the amount of rows necessary for the cycles in that day. For example, I may plan to run product 2 and it has 6 cycles for the day. Then on day 3 I choose to run product 4, and the chart will fill in 10 rows of data. I can get it to work for 1 day and 1 product, but not more than that. Any ideas? Below is an example of what I want it to look like. I will need it to fill in for 5 days, so it could be anywhere from 25 rows to 75 rows that will need to populate. and these rows will drive the horizontal bare chart.

B

 

[Peter_SSs]

Welcome to the MrExcel board!

Below is an example of what I want it to look like.

Where does this information get drawn from?

if I choose say product 1 and it can do 5 cycles in one day, then the array that feeds the graph will populate with 5 rows, and will look up the runtimes for product 1. The formula would then need to look at day 2, and populate the amount of rows necessary for the cycles in that day. For example, I may plan to run product 2 and it has 6 cycles for the day. Then on day 3 I choose to run product 4, and the chart will fill in 10 rows of data.

How and where would you be indicating the days and products that you want to choose and where do we find how many cycles per day each product can do?

For answers to both of the above it would be best if you gave sample data and layout with XL2BB so that we could easily copy for testing (which we cannot do from an image).
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

 

[Woodchuck76]

unfortunately I am not allowed to download files, such as the xl2bb add-in. is it possible to submit a stripped down version of my file?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dynamic formula to show the day and the number of cycles that can be ran that day
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Woodchuck76]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dynamic formula to show the day and the number of cycles that can be ran that day
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

seriously? Rather than offer any guidance on the alternative to doing xl2bb....I get a reprimand for cross posing? Complete nonsense. Would be nice for the forum to actually offer a solution, instead of nit-pick...

 

[Fluff]

If you had answered Peter's question, it would have helped people to help you.
Instead you did not answer them, broke the rules & complain it's all our fault.

 

[Peter_SSs]

Complete nonsense.

It seems that you did not ..

... follow & read the link at the end of the rule too!

.. otherwise you would understand why this is an issue.

Also interesting that there was such a strong negative response here and yet a polite apology in the other forum a few minutes later to a very similar post to Fluff's here by a moderator in that forum about the same rule.