How can I do this with or without Macro/VB code?

I want to create a Gantt Chart like graphic by coloring a grid (columns 1-52
weeks, rows dictated by number of Projects). The Design task would be colored
red, Install Hardware blue etc. Each project would have 1 row (only) where
Design, Install Hardware etc would be colored in the appropriate cells on the
grid (Project1 Design task would show in 26th cell in the row, Install
Hardware 37th thru 40th)

Note I will create the data from MS Project, but I need to present it
succinctly in Excel for my client.



ProjectID TaskID Start Week Duration

Project1 Design 26 1
Project1 Install Hardware 37 4
Project1 Install Software 41 4
Project1 Configure 49 1
Project1 Prep 50 2
Project1 Support 52 1

Project2 Design 2 1
Project2 Install Hardware 15 2
Project2 Install Software 17 3
Project2 Configure 20 1
Project2 Prep 21 1
Project2 Support 22 4

See if this doesn't work for you. I think you'll find the code easy enough
to change for your real world situation.
http://www.jlathamsite.com/uploads/MakeGanttCharts.xls (in 97-2003 format)


"MSPLearner" wrote:

How can I do this with or without Macro/VB code?

I want to create a Gantt Chart like graphic by coloring a grid (columns 1-52
weeks, rows dictated by number of Projects). The Design task would be colored
red, Install Hardware blue etc. Each project would have 1 row (only) where
Design, Install Hardware etc would be colored in the appropriate cells on the
grid (Project1 Design task would show in 26th cell in the row, Install
Hardware 37th thru 40th)

Note I will create the data from MS Project, but I need to present it
succinctly in Excel for my client.



ProjectID TaskID Start Week Duration

Project1 Design 26 1
Project1 Install Hardware 37 4
Project1 Install Software 41 4
Project1 Configure 49 1
Project1 Prep 50 2
Project1 Support 52 1

Project2 Design 2 1
Project2 Install Hardware 15 2
Project2 Install Software 17 3
Project2 Configure 20 1
Project2 Prep 21 1
Project2 Support 22 4

This is precisely what I need. I really appreciate your help. Thank you

I am a novice at VB, so will need to get help from a colleague.

Thanks again.

"MSPLearner" wrote:

How can I do this with or without Macro/VB code?

I want to create a Gantt Chart like graphic by coloring a grid (columns 1-52
weeks, rows dictated by number of Projects). The Design task would be colored
red, Install Hardware blue etc. Each project would have 1 row (only) where
Design, Install Hardware etc would be colored in the appropriate cells on the
grid (Project1 Design task would show in 26th cell in the row, Install
Hardware 37th thru 40th)

Note I will create the data from MS Project, but I need to present it
succinctly in Excel for my client.



ProjectID TaskID Start Week Duration

Project1 Design 26 1
Project1 Install Hardware 37 4
Project1 Install Software 41 4
Project1 Configure 49 1
Project1 Prep 50 2
Project1 Support 52 1

Project2 Design 2 1
Project2 Install Hardware 15 2
Project2 Install Software 17 3
Project2 Configure 20 1
Project2 Prep 21 1
Project2 Support 22 4