gantt charts

Thursday, October 30, 2008
Work

Add a Gantt Chart To Your Google Spreadsheet

10:30AM Lifehacker US Edition | Schedule and keep track of a project over time with a Gantt chart from a spreadsheet created in Google Docs thanks to a gadget from Viewpath. You just need to enter task start and end dates, percent completed, and track dependencies; the folks at Viewpath created a handy demonstration and tutorial video. It’s free and relatively easy (though you may run into platform and browser problems if you aren’t using Internet Explorer or Firefox, and even then, I had no luck on a Mac). Probably best for smaller projects, as it would be difficult to display or print a particularly long or complicated series of tasks. But it’s a good introductory tool and costs infinitely less than Microsoft Project. Featured gadget: Gantt charts in spreadsheets [Official Google Blog] More »
Share Comment

Friday, March 14, 2008

Create an Excel Gantt Chart with Conditional Formatting

1:00PM Gina Trapani | Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart. Conditional formatting makes a cell look a certain way based on its contents. A Gantt chart maps out deadlines within a project. Chandoo’s Excel Gantt chart combines a calendar and to-do list to display what has to be completed when in a good-looking table layout. If you don’t want to set up the sheet yourself, download an Excel Gantt chart template here. Here’s more on using conditional formatting in your spreadsheets. More »
Share Comment