Excel 2007 : Excel 2007 Gantt Chart??

**twilson37** · 11-14-2011, 11:10 AM

I have a series of projects running at various times throughout the year. I'd like to create a gantt chart reflecting this information.

Project A runs January through December.
Project B runs April through August
Project C runs June through November
Project D runs February through September
Project E runs January through May, August through December

How could I display this in Gantt Chart format?
I want chart labels along X axis to read Jan, Feb, Mar, Apr etc.
I want chart labels along Y axis to reflect Project Name.
Data Area would show months blocked out in which project work is scheduled.

Thanks in advance! Sorry to be such a pain. I'm very new to Excel and my management feels things like training are unnecessary expenditures

**Andy Pope** · 11-14-2011, 11:24 AM

Gantt charts are basically stacked bar charts. You do need to manipulate your data in order to get the gap between start and finish plotted rather than simply stacking 2 dates.

When you have 2 or more phases to a project you need to include additional series, similar to the first series, to pad the gaps.

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

**twilson37** · 11-14-2011, 12:06 PM

Thanks for the info Andy! It is much appreciated!

**twilson37** · 11-14-2011, 03:14 PM

I'm very nearly there...I have a basic gantt chart with numbers 1 - 12 representing the months Jan - Dec on the X axis. I know the numbers are needed for calculation purposes, but is there any way to make the labels show the names of the months instead of numbers?