Trying to build a load plan. need help ! thanks

[Manxman12]

Hi, i'm trying to build load plan in which i require multipul shop cage counts to add up and then see where they fit on to a wagon. i have got that part done but im wondering if it is possible to fill in, as many boxes with a shop name as there are in the sum?

wagon would be 3 boxes wide ,by 15 long.

any pointers would be great!!!!!

andy

 

[Legacy 143009]

So you must be careful not to exceed 45 boxes each time. Where is the question part? Can you provide some sample data?

 

[Manxman12]

hi,
i have been using bar charts to display this but obviously this cannot have two shops next to each other
i need to have multipul shops delivery cages on an excel diagram .
the cage amounts add up and are displayed in the total boes, ie
eg shop no 1 3 cages, shop no 2 4 cages, shop no 3 5 cages
ie
no 1 no 1 no1
no2 no2 no2
no2 no 3 no3
no 3 no 3 no 3

and so on and so forth.
aslo i could do with being able to change the order they are in.