Archive › Excel Tips

How to Create a RAG (Red, Amber, Green) Report for your Gantt Chart

A RAG status report is frequently using in project management to provide a visual indication of project performance. The actual definition of the thresholds used to determine the status can vary from project to project, however a typical interpretation for each condition is: If a status is Red, then some form of escalation is immediately […]

Comments ( 0 )

Helpful Excel Tips I learned at Launchexcel.com

I came across an interesting site while looking for new information about how to use Excel for project management tasks and gather ideas for further improvements to GanttDiva. You should check out Victor Chan’s website, www.launchexcel.com . I particularly like the description of the project timeline as this is a very nice way of putting together a project roadmap […]

Comments ( 0 )

Enabling Macros – Excel 2007

In case you are not sure how to enable macros on your copy of Excel 2007 to use GanttDiva and start creating your Gantt chart, here is a step by step approach: Step 1 – From the initial open page of Excel, click on the button with the Office Logo as shown in the image […]

Comments ( 0 )

Enabling Macros – Excel 2010

If macros are not enabled on your copy of Excel, then GanttDiva will not work. Here are the steps required to ensure that macros can run on your copy of Excel of Excel 2010 and you can use GanttDiva to create your Gantt chart based project schedule. Step 1 – From the File menu, select […]

Comments ( 0 )