Chart a Production Schedule for Multiple Projects

A

awiegmann

New Member
Joined
Jun 27, 2012
Messages
1
I need to chart a schedule that has date across x axis and the tasks along the y axis. The task for each project should look like a little bar along the timeline with each project being a different color code. I have been able to figure this out for a single project timeline but not how to integrate the other projects with the same task list along different dates (and color code by project). I thought a bar graph of some sort may work but can't figure out how to create it with the added dimension! Any ideas?!?
[TABLE="width: 807"]
<colgroup><col><col><col><col></colgroup><tbody>[TABLE="width: 807"]
<colgroup><col><col><col><col></colgroup><tbody>[TABLE="width: 807"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Program[/TD]
[TD]Task[/TD]
[TD]Start Date[/TD]
[TD]Target Completion Date[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Targeted Offer List To Company M[/TD]
[TD]06/01/12[/TD]
[TD]06/04/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Company M Marketing reviews Offer List w/ Company M Merchandising[/TD]
[TD]06/08/12[/TD]
[TD]06/12/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Review offer list, make final adjustments and update[/TD]
[TD]06/12/12[/TD]
[TD]06/18/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Brochure Creative Development[/TD]
[TD]06/14/12[/TD]
[TD]08/08/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Review Potential Offer List & Offer Copy before Coupon Creation & Targeting[/TD]
[TD]06/18/12[/TD]
[TD]06/25/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Run distribution numbers for potential offer list[/TD]
[TD]06/19/12[/TD]
[TD]06/25/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]March Program Results Delivered[/TD]
[TD]06/25/12[/TD]
[TD]06/25/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Targeted Offer List To Company M[/TD]
[TD]06/28/12[/TD]
[TD]07/01/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Company M Marketing reviews Offer List w/ Company M Merchandising[/TD]
[TD]07/05/12[/TD]
[TD]07/09/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Targeted Offer List To Company M[/TD]
[TD]07/05/12[/TD]
[TD]07/08/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Review offer list, make final adjustments and update[/TD]
[TD]07/09/12[/TD]
[TD]07/15/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Finalize Offer List[/TD]
[TD]07/10/12[/TD]
[TD]07/17/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Brochure Creative Development[/TD]
[TD]07/11/12[/TD]
[TD]09/04/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Company M Marketing reviews Offer List w/ Company M Merchandising[/TD]
[TD]07/12/12[/TD]
[TD]07/16/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Review Potential Offer List & Offer Copy before Coupon Creation & Targeting[/TD]
[TD]07/15/12[/TD]
[TD]07/22/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Run distribution numbers for potential offer list[/TD]
[TD]07/16/12[/TD]
[TD]07/22/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Secure Brands Participation[/TD]
[TD]07/16/12[/TD]
[TD]08/27/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Review offer list, make final adjustments and update[/TD]
[TD]07/16/12[/TD]
[TD]07/22/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Secure Coupon Images[/TD]
[TD]07/17/12[/TD]
[TD]07/24/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Secure and Develop High Res Bar Codes[/TD]
[TD]07/17/12[/TD]
[TD]07/24/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Brochure Creative Development[/TD]
[TD]07/18/12[/TD]
[TD]09/11/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]March Program Results Delivered[/TD]
[TD]07/22/12[/TD]
[TD]07/22/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Secure Brands Participation[/TD]
[TD]07/22/12[/TD]
[TD]09/23/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Review Potential Offer List & Offer Copy before Coupon Creation & Targeting[/TD]
[TD]07/22/12[/TD]
[TD]07/29/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Run distribution numbers for potential offer list[/TD]
[TD]07/23/12[/TD]
[TD]07/29/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Updated household decile file with full address indicator delivered[/TD]
[TD]07/25/12[/TD]
[TD]07/28/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Coupon Development[/TD]
[TD]07/25/12[/TD]
[TD]08/02/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Target all offers on finalized list with updated household file[/TD]
[TD]07/27/12[/TD]
[TD]08/03/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]March Program Results Delivered[/TD]
[TD]07/29/12[/TD]
[TD]07/29/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Secure Brands Participation[/TD]
[TD]07/29/12[/TD]
[TD]09/30/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Targeted Offer List To Company M[/TD]
[TD]08/06/12[/TD]
[TD]08/09/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Finalize Offer List[/TD]
[TD]08/06/12[/TD]
[TD]08/13/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Household Merge Completed[/TD]
[TD]08/06/12[/TD]
[TD]08/10/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Final Coupon Creative to Printer[/TD]
[TD]08/07/12[/TD]
[TD]08/08/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Final Brochure Creative Artwork to Printer[/TD]
[TD]08/07/12[/TD]
[TD]08/08/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]HH counts by offer approval[/TD]
[TD]08/09/12[/TD]
[TD]08/13/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Final Proof Approvals / Targeting File Completed[/TD]
[TD]08/09/12[/TD]
[TD]08/13/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Company M Marketing reviews Offer List w/ Company M Merchandising[/TD]
[TD]08/13/12[/TD]
[TD]08/17/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Secure Coupon Images[/TD]
[TD]08/13/12[/TD]
[TD]08/20/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Secure and Develop High Res Bar Codes[/TD]
[TD]08/13/12[/TD]
[TD]08/20/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Finalize Offer List[/TD]
[TD]08/13/12[/TD]
[TD]08/20/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Printing[/TD]
[TD]08/14/12[/TD]
[TD]08/21/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Review offer list, make final adjustments and update[/TD]
[TD]08/17/12[/TD]
[TD]08/23/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Brochure Creative Development[/TD]
[TD]08/19/12[/TD]
[TD]10/13/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Secure Coupon Images[/TD]
[TD]08/20/12[/TD]
[TD]08/27/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Secure and Develop High Res Bar Codes[/TD]
[TD]08/20/12[/TD]
[TD]08/27/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Updated household decile file with full address indicator delivered[/TD]
[TD]08/21/12[/TD]
[TD]08/24/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Coupon Development[/TD]
[TD]08/21/12[/TD]
[TD]08/29/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]Drop Ship to Indy & Mail[/TD]
[TD]08/21/12[/TD]
[TD]08/27/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Review Potential Offer List & Offer Copy before Coupon Creation & Targeting[/TD]
[TD]08/23/12[/TD]
[TD]08/30/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Target all offers on finalized list with updated household file[/TD]
[TD]08/23/12[/TD]
[TD]08/30/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Run distribution numbers for potential offer list[/TD]
[TD]08/24/12[/TD]
[TD]08/30/12[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]In Home Date[/TD]
[TD]08/28/12[/TD]
[TD]09/01/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Updated household decile file with full address indicator delivered[/TD]
[TD]08/28/12[/TD]
[TD]08/31/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Coupon Development[/TD]
[TD]08/28/12[/TD]
[TD]09/05/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Targeted Offer List To Company M[/TD]
[TD]08/29/12[/TD]
[TD]09/03/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]March Program Results Delivered[/TD]
[TD]08/30/12[/TD]
[TD]08/30/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Secure Brands Participation[/TD]
[TD]08/30/12[/TD]
[TD]11/01/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Target all offers on finalized list with updated household file[/TD]
[TD]08/30/12[/TD]
[TD]09/06/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Household Merge Completed[/TD]
[TD]09/02/12[/TD]
[TD]09/06/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Final Coupon Creative to Printer[/TD]
[TD]09/03/12[/TD]
[TD]09/04/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Final Brochure Creative Artwork to Printer[/TD]
[TD]09/03/12[/TD]
[TD]09/04/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]HH counts by offer approval[/TD]
[TD]09/05/12[/TD]
[TD]09/09/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Final Proof Approvals / Targeting File Completed[/TD]
[TD]09/05/12[/TD]
[TD]09/09/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Company M Marketing reviews Offer List w/ Company M Merchandising[/TD]
[TD]09/07/12[/TD]
[TD]09/11/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Household Merge Completed[/TD]
[TD]09/09/12[/TD]
[TD]09/13/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Printing[/TD]
[TD]09/10/12[/TD]
[TD]09/17/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Final Coupon Creative to Printer[/TD]
[TD]09/10/12[/TD]
[TD]09/11/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Final Brochure Creative Artwork to Printer[/TD]
[TD]09/10/12[/TD]
[TD]09/11/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Review offer list, make final adjustments and update[/TD]
[TD]09/11/12[/TD]
[TD]09/17/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]HH counts by offer approval[/TD]
[TD]09/12/12[/TD]
[TD]09/16/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Final Proof Approvals / Targeting File Completed[/TD]
[TD]09/12/12[/TD]
[TD]09/16/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Brochure Creative Development[/TD]
[TD]09/13/12[/TD]
[TD]11/07/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Finalize Offer List[/TD]
[TD]09/14/12[/TD]
[TD]09/21/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Review Potential Offer List & Offer Copy before Coupon Creation & Targeting[/TD]
[TD]09/17/12[/TD]
[TD]09/24/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]Drop Ship to Indy & Mail[/TD]
[TD]09/17/12[/TD]
[TD]09/23/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Printing[/TD]
[TD]09/17/12[/TD]
[TD]09/24/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Run distribution numbers for potential offer list[/TD]
[TD]09/18/12[/TD]
[TD]09/24/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Secure Coupon Images[/TD]
[TD]09/21/12[/TD]
[TD]09/28/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Secure and Develop High Res Bar Codes[/TD]
[TD]09/21/12[/TD]
[TD]09/28/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]March Program Results Delivered[/TD]
[TD]09/24/12[/TD]
[TD]09/24/12[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD]In Home Date[/TD]
[TD]09/24/12[/TD]
[TD]09/28/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]Drop Ship to Indy & Mail[/TD]
[TD]09/24/12[/TD]
[TD]09/30/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Secure Brands Participation[/TD]
[TD]09/28/12[/TD]
[TD]11/26/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Updated household decile file with full address indicator delivered[/TD]
[TD]09/29/12[/TD]
[TD]10/02/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Coupon Development[/TD]
[TD]09/29/12[/TD]
[TD]10/08/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Target all offers on finalized list with updated household file[/TD]
[TD]10/01/12[/TD]
[TD]10/08/12[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD]In Home Date[/TD]
[TD]10/01/12[/TD]
[TD]10/05/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Finalize Offer List[/TD]
[TD]10/09/12[/TD]
[TD]10/16/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Household Merge Completed[/TD]
[TD]10/11/12[/TD]
[TD]10/15/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Final Coupon Creative to Printer[/TD]
[TD]10/11/12[/TD]
[TD]10/12/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Final Brochure Creative Artwork to Printer[/TD]
[TD]10/11/12[/TD]
[TD]10/12/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]HH counts by offer approval[/TD]
[TD]10/15/12[/TD]
[TD]10/18/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Final Proof Approvals / Targeting File Completed[/TD]
[TD]10/15/12[/TD]
[TD]10/18/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Secure Coupon Images[/TD]
[TD]10/16/12[/TD]
[TD]10/23/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Secure and Develop High Res Bar Codes[/TD]
[TD]10/16/12[/TD]
[TD]10/23/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Printing[/TD]
[TD]10/19/12[/TD]
[TD]10/26/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Updated household decile file with full address indicator delivered[/TD]
[TD]10/24/12[/TD]
[TD]10/26/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Coupon Development[/TD]
[TD]10/24/12[/TD]
[TD]11/01/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Target all offers on finalized list with updated household file[/TD]
[TD]10/26/12[/TD]
[TD]11/02/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]Drop Ship to Indy & Mail[/TD]
[TD]10/26/12[/TD]
[TD]11/01/12[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]In Home Date[/TD]
[TD]11/02/12[/TD]
[TD]11/06/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Household Merge Completed[/TD]
[TD]11/05/12[/TD]
[TD]11/09/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Final Coupon Creative to Printer[/TD]
[TD]11/06/12[/TD]
[TD]11/07/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Final Brochure Creative Artwork to Printer[/TD]
[TD]11/06/12[/TD]
[TD]11/07/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]HH counts by offer approval[/TD]
[TD]11/08/12[/TD]
[TD]11/12/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Final Proof Approvals / Targeting File Completed[/TD]
[TD]11/08/12[/TD]
[TD]11/12/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Printing[/TD]
[TD]11/13/12[/TD]
[TD]11/20/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]Drop Ship to Indy & Mail[/TD]
[TD]11/20/12[/TD]
[TD]11/26/12[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD]In Home Date[/TD]
[TD]11/27/12[/TD]
[TD]12/01/12[/TD]
[/TR]
</tbody>[/TABLE]
</tbody>[/TABLE]
</tbody>[/TABLE]
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
You must log in or register to reply here.

Similar threads

D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
513
dshtesy
D
E
  • Question Question
Pulling together data from multiple MS Forms spreadsheets and displaying into a single league table
Replies
6
Views
383
excelnewbie999
E
D
  • Solved
Is there a quick way to create / fill this list
2 3
Replies
20
Views
583
Eric W
Eric W
tezza
  • Solved
Autosum specific rows and columns
Replies
2
Views
301
tezza
tezza
T
  • Solved
Looking for VBA Code to Conditionally Format Time Tracker on Entry
Replies
3
Views
274
Tara_A_Data
T

Forum statistics

Threads
1,226,511
Messages
6,191,467
Members
453,658
Latest member
healmo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top