Posted by: Craig Hatmaker
development, excel, ListObjects, Microsoft Excel, Tables, tutorial, vba
Introducing a new approach to Gantt Charts in XL – BabyGantt.xls
This type creates a stacked bar chart with the first series being the duration from project start to task start. This series’ fill color is set to “No Fill” so it appears that the second series – the actual task – is floating by itself. It is a clever and effective means to small Gantts – about 30 or less tasks. It can leverage XL2007 and later’s improved aesthetics.
This type uses spreadsheet cells and conditional formatting to make colored cells into Gantt Chart bars. This method can accommodate many more tasks but also creates a lot of formulas and calculations.
BXL’s Baby Gantt uses shapes and VBA. It has the advantage of Conditional Formatting’s “many tasks” without the formula overhead. It also shares the Bar Chart’s improved graphics capabilities. But best of all, there’s no setup – at least – not for the chart.
All Gantt Charts require tasks and dates. But that’s all Baby Gantt requires us to enter. We don’t need to add and configure charts or enter and autofill formulas across massive ranges. The VBA in Baby Gantt reads our task entries and generates the graphics on the fly. And because it is Excel, we can use formulas to calculate task start and end dates.
You can build BabyGantt.xls yourself or download it from my DropBox. Here is a link to the instructions:
The instructions include:
- User Instructions – Step by Step guides on how to enter your project with examples
- Download Instructions – Links to a fully functioning, totally free, unprotected BabyGantt.xls
- Technical Documentation – All of the code with explanations and all data validation entries with screenshots.
Moma Gantt Testers Wanted!
If you would like to be part of the MomaGantt.xls test team please email me at Craig_Hatmaker at Yahoo.com