Hessel de Walle's Blog

In Crystal Reports it is very easy to create a Gantt Chart . You just need a table with a starting date and an ending data. And there you go. In the given example I used the data from the Orders table from the database Northwind . I just took the data from July 1996. The regular chart looks like this: I just chose Color by series to get the same color for all the bars. Now I created a Gantt Chart with different colors before and after a given date (July 15 1996, in this case). Here Orange stands for Done and Green for To Do . How did I create this one? First I created a parameter GivenDate with 15-7-1996 as Default value. Next I created a Formula Field BeforeGivenDate : if {Orders.OrderDate}<{?GivenDate} and {Orders.ShippedDate} < {?GivenDate} then     {Orders.ShippedDate} - {Orders.OrderDate} else     (if {Orders.OrderDate}< {?GivenDate} and {Orders.ShippedDate}>= {?GivenDate} then         {?GivenDate}- {O...

On the internet you can find many examples of Excel Gantt charts, either created as a graph or using conditional formatting and how to build them. My example has some additions to the graph type of the Gantt chart: A date line (the black vertical line). Different colors for the task or part of a task before and after a specific date (in this case July 31). Here are the data, from A1:C27 : Task Start Date Duration in days Task 1 3-6-2013 1 Task 2 4-6-2013 1 Task 3 4-6-2013 5 Task 4 11-6-2013 1 Task 5 11-6-2013 12 Task 6 25-6-2013 3 Task 7 28-6-2013 1 Task 8 28-6-2013 4 Task 9 4-7-2013 3 Task 10 9-7-2013 1 Task 11 10-7-2013 3 Task 12 15-7-2013 3 Task 13 18-7-2013 1 Task 14 21-7-2013 5 Task 15 24-7-2013 7 Task 16 27-7-2013 4 Task 17 30-7-2013 3 Ta...