londonblue
Topgun Pilot
- Joined
- Feb 18, 2004
- Messages
- 19,191
I'm hoping we have some kind of excel expert on here that can help me out.
Let's assume I have about 500 cars all that need radios installed. I know the dates the installs will happen (because this has been planned well in advance) and have a column in my data that creates the "week beginning" date from the install date. The actual installs will happen from now to some time in 2018. Obviously all cars have a reg number that is unique.
What I would like to show is the actual reg numbers per week. I don't want the totals to be installed during the week, I want to show the actual reg numbers, almost like a set of milestones on a project plan. To make it more difficult I also want to be able to show the four different makes of car separately in swim lanes, although I could frig this bit by putting four different "graphs" next to each-other.
Any help would be gratefully received.
Let's assume I have about 500 cars all that need radios installed. I know the dates the installs will happen (because this has been planned well in advance) and have a column in my data that creates the "week beginning" date from the install date. The actual installs will happen from now to some time in 2018. Obviously all cars have a reg number that is unique.
What I would like to show is the actual reg numbers per week. I don't want the totals to be installed during the week, I want to show the actual reg numbers, almost like a set of milestones on a project plan. To make it more difficult I also want to be able to show the four different makes of car separately in swim lanes, although I could frig this bit by putting four different "graphs" next to each-other.
Any help would be gratefully received.