1. 

   ajdjackson, Member

   Hi

   Looking for a bit of advice.

   I need to create a production line scheduler. Each production line will have seceral items scheduled to run in a priority order. Each item will have a variable time to produce.

   I need to create something along the lines of the Gantt chart.

   My question is - can I have mutiplie columns for the labels? To explain I need to have the item description, qty required, qty made, hrs/per etc and then the gantt chart if you follow me.

   Form you r demo it looks like I can only have a 'label'. Concating the columns together would be a solution but item descriptions etc would be varoius lengths.

   Is this possible or is there a another way to do what I wish?

   Thanks

   Jake
2. 

   myDBR Team, Key Master

   Could you show a sample chart (a sketch) how that would look like?

   --
   myDBR Team
3. 

   ajdjackson, Member

   Hi

   I'll email you a spreadsheet with a rough example.

   Many thanks

   Jake
4. 

   myDBR Team, Key Master

   Jake,
   you could simply use a crosstab for that. See an example.

   --
   myDBR Team
5. 

   ajdjackson, Member

   Thanks for that.

   I was thinking along those ie cellstyle but I thought that maybe the Gantt chart could be extended.

   Cheers

   Jake

Reply

You must log in to post.