Gantt Chart Links

There is a wealth of Gantt chart resources for Excel. These are split between techniques which use a floating bar chart to represent the timelines, and others which use conditional formatting to color cells to represent timelines.

I've written an article for Tech Trax e-zine which gives a general introduction to both types of Gantt charts: Gantt Charts in Microsoft Excel. I've also written an article on this web site dealing with Advanced Techniques for Gantt Charts in Microsoft Excel. The following is a brief list of additional internet resources dealing with Gantt charts.

Floating Bar Charts

MSKB articles (http://support.microsoft.com)

Q213447 Visual Basic Module to Create Gantt Chart
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q213447

Q152820 XL97 Create Gantt Chart Using Hours as the Scale
    http://support.microsoft.com/default.aspx?scid=kb;en-us;152820

Q213915 XL2000 Create Gantt Chart Using Hours as the Scale
    http://support.microsoft.com/default.aspx?scid=kb;en-us;213915

INFO: Gantt Chart Sample Add-In Available for Download
COM add in in VB6 for Excel 2000+
    http://support.microsoft.com/default.aspx?scid=kb;en-us;254008

Track multiple projects with a Gantt chart
    http://www.microsoft.com/mac/excelx/excelx_main.asp?embfpath=howtox&embfname=xl_ganttchart.asp

John Walkenbach's The Spreadsheet Page

How to create an attractive "time line" (Gantt) chart in Excel.
    http://j-walk.com/ss/excel

Tushar Mehta

Gantt Chart Add-in
    http://www.tushar-mehta.com/excel/software/ganttchart/index.html

Tushar's Floating Bar Chart Tutorial
    http://tushar-mehta.com/excel/newsgroups/floating_bars/tutorial/index.html

Andy Pope

Sample Workbook
    http://www.andypope.info/ngs/ng11.htm

Aaron Blood, XL-Logic.com

"Examples of how to set up Gantt charts for tracking processes. Three examples including one that combines an XY scatter chart to pick out processes that take only one unit of time to complete."
    http://www.xl-logic.com/xl_files/charts/chart_gantt.zip

Dave Steppan

"Did you ever need to make a Gantt chart? If you have, and checked into the price of Microsoft Project you would think that's a real expensive way to make a bloody Gantt chart. Here is an Excel macro that makes a very value priced Gantt chart in a painless manner. It could be more beautiful but couldn't be cheaper."
    http://www.geocities.com/SiliconValley/Network/1030/gantt.zip

Andy Wiggins (Byg Software)

    http://www.bygsoftware.com/examples/examples.htm#Project Planning

John Lacher

GANTT Chart for Scheduling Resources
    http://www.lacher.com/examples/lacher24.htm

Gantt Chart Builder

A download for constructing Gantt charts (site unclear as to whether it's free)
    http://www.simtel.net/pub/pd/61062.shtml

Worksheets with cell fill patterns (probably conditional formatting)

Vertex^42 - The Excel Nexus

Free Excel Gantt Chart Template
    http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

Manual Gantt Charting in Excel - David Seah

    http://davidseah.com/blog/comments/manual-gantt-charting-in-excel/

Ole Erlandsen

    http://www.erlandsendata.no/english/downloads/charts.htm

Purdue Department of English

Of all places!
    http://pw.english.purdue.edu/resources/doc/gantt/index.shtml
    http://pw.english.purdue.edu/resources/doc/pdfs/ganttexcel.pdf

The GantTool

A freeware solution seemingly based on worksheet formatting.
    http://come.to/TheGantTool

UMN

    href=http://www.me.umn.edu/courses/me4054/assignments/gantt.html

Mr. Excel

    http://www.mrexcel.com/tip058.shtml

SMSU

straightforward instructions
    http://courses.smsu.edu/mas006f/files/ganttinstr.pdf

XL-EasyGantt

A free utility based on an Excel template which combines conditional worksheet formatting with VBA procedures to facilitate management of the Gantt worksheet data.
    http://www.xleasygantt.com