Now, I just need to focus on creating time  headings and
formatting. The headings could be done with a macro also (since this is a
forecast, the start  month will change as you move forward.



To your point "I do not think it is necessarily the most efficient way to do
this", I agree. While I call it a Gantt chart  (that's how most people
understand), it's actually (what I call) a Heat Map. It is not intended for
tracking projects. It is more a program level view (to identify cross
project issues) as to where the work (and work demand) is concentrated.
Ideally (not sure excel  is the right tool?), the chart could be just one row
that has all the projects  'stamped' on it. Each project  would stamp some
color on the right cells. The darkest spots would be areas of interest (or
concern) and investigation. However, I think I am dreaming:-).