|
|
Peltier Tech
Excel Dashboards
Books at Amazon.com
|
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 ChartsMSKB articles (http://support.microsoft.com)Q213447 Visual Basic Module to Create Gantt Chart Q152820 XL97 Create Gantt Chart Using Hours as the Scale Q213915 XL2000 Create Gantt Chart Using Hours as the Scale INFO: Gantt Chart Sample Add-In Available for Download Track multiple projects with a Gantt chart John Walkenbach's The Spreadsheet PageHow to create an attractive "time line" (Gantt) chart in Excel. Tushar MehtaGantt Chart Add-in Tushar's Floating Bar Chart Tutorial Andy PopeSample Workbook 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." 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." Andy Wiggins (Byg Software)http://www.bygsoftware.com/examples/examples.htm#Project Planning John LacherGANTT Chart for Scheduling Resources Gantt Chart BuilderA download for constructing Gantt charts (site unclear as to whether it's free) Worksheets with cell fill patterns (probably conditional formatting)Vertex^42 - The Excel NexusFree Excel Gantt Chart Template Pointy Haired DilbertFree Excel Gantt Chart Template and Tutorial - Project Management Using Excel Manual Gantt Charting in Excel - David Seahhttp://davidseah.com/blog/comments/manual-gantt-charting-in-excel/ Ole Erlandsenhttp://www.erlandsendata.no/english/downloads/charts.htm Purdue Department of EnglishOf all places! The GantToolA freeware solution seemingly based on worksheet formatting. UMNhref=http://www.me.umn.edu/courses/me4054/assignments/gantt.html Mr. Excelhttp://www.mrexcel.com/tip058.shtml SMSUstraightforward instructions XL-EasyGanttA free utility based on an Excel template which combines conditional worksheet formatting with VBA procedures to facilitate management of the Gantt worksheet data. |
Peltier Technical Services, Inc.Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2010. All rights reserved. |
