Home | Blog 

Using Excel a new level of flexibility in gantt chart planning

Posted by Marcus Shane on Wednesday, September 1, 2010

Contrary to the beliefs of the main gantt chart software packages, every project and every plan has its own special requirements.

Some project plans may require you to measure and manage effort for billing purposes.  Other plans may need minute based planning.  There are so many different requirements of project planning that it is difficult to build these into a single gantt chart tool.

This is where MS Excel has some very substantial advantages in preparing gantt charts.  The major, and o...


Continue reading...
 

How Dependencies save you time when planning and managing your gantt chart.

Posted by Marcus Shane on Wednesday, September 1, 2010 In : Gantt Chart for Management Vs Gantt Chart for Planning 
 

A gantt chart is a visual representation of time that enables simple and effective project planning.  A particularly useful feature of leading gantt chart solutions is the ability to create dependencies between tasks.  There are 4 types of dependencies that can be created.  Finish to start, Start to Start, Start to Finish and Finish to Finish.  Leading project management software and gantt chart creation templates in excel can incorporate the use of dependencies.

Dependencies are particul...


Continue reading...
 

The Making of Chart Gantt Ultimate

Posted by Marcus Shane on Wednesday, August 4, 2010 In : ChartGantt Ultimate 
The features discussed below are only available in Chart Gantt Ultimate, to be released in August 2010

 We set ourselves the ambitious task of re-creating standard functionality in major project planning software tools.  One of the main challenges in building an excel based gantt chart is the use of WBS (Work Breakdown Structure).  There are a number of issues with the use of WBS in excel.

Whilst we have seen other excel based tools that attempt to offer WBS, they do this via a combination of m...
Continue reading...
 

We did it! View by day, by week or by month! Chartgantt 2.0 Release

Posted by Marcus Shane on Tuesday, June 22, 2010 In : Chartgantt 2.0 Release 
We are very excited by the launch of Chart Gantt 2.0.  We set ourselves the ambitious task of adding significant functionality to Chart Gantt without the need for macro's.  The issue with macro driven Excel based Gantt Charts is that they are inherently unpredictable.

By steering clear of Macro's we have created a stable excel platform that just works.  This enables users now to view as much as 3 years of chart in the one screen.  This is a minor breakthrough in the Gantt Chart world, and took...
Continue reading...
 

Upcoming Update to Chartgantt Products

Posted by Marcus Shane on Monday, June 21, 2010 In : Chartgantt Updates 
Following on from the popularity of the Chartgantt products, we are currently working to extend the functionality of all Chartgantt products. 

We are pushing the limits of excel, but are hoping to enable users to toggle between daily, weekly and monthly gantt chart views on a single sheet.  This means that users will only need to enter their data once, the data on the left will remain, but the gantt chart timeframe and bars will update automatically when switching between views.

This ambitious...
Continue reading...
 

Gantt Chart for Management Vs Gantt Chart for Planning

Posted by Marcus Shane on Monday, February 15, 2010 In : Gantt Chart for Management Vs Gantt Chart for Planning 
Management Gantt Charts are significantly more complex and tailored than Planning Gantt Charts.

The incorporation of actual figures into the planning process significantly complicates any planning model, as anyone who has used Microsoft Project to manage a project will attest.

The significant issue with the vast majority of management Gantt Charts is that they are driven by duration rather than effort.  Whilst tools such as MS Project do allow for effort driven management, the underlying premis...
Continue reading...
 

Building Gantt Charts in Excel

Posted by Marcus Shane on Monday, February 15, 2010 In : Chart Gantt Build Your Own 
For anyone who would like to take the time to build their own excel based templates please see the below links and blogs.

In our view, all of these approaches are time consuming and allow for significantly less flexibility than the Chart Gantt solution.  However please explore these options if you are curious and have some time to kill.

  1. Building charts Using the Chart Function within MS Excel
  2. This approach whilst it does produce a clumsy result will draw gantt charts.  This approach does not...

Continue reading...
 
 

About Me