(last updated on April 29, 2014)
I was putting together a development plan and bid for a new project, and found myself using my Gantt Chart Spreadsheet, weekly version to visualize how the project might take. That’s when I discovered that I hadn’t set it up for an arbitrary starting date.
So I fixed it.
The new weekly version is available to download as version 5, over on the Gantt Excel page. This is merely useful for generating a kind of “gantt graph paper”; it’s not a full-blown project management tool with auto-allocation and calculation of time. It’s good for outlining and quick estimating, though.
As a bonus, the new weekly version can be cut and paste into other spreadsheets (which I needed to do) and it still works. Select the range
A1:F17 in your cell copy, and paste into your own worksheet. To extend the range of days, select the last two columns and stretch ’em to use ordinary Excel range extrapolation. If this doesn’t make sense, watch the video on the Excel Gantt page and this may help.