I am not sure about you, but I feel this is a pretty cool way to generate gantt chart, without open up your wallet to purchase a project management application. This example is more detailed, and therefore more complicated. There are two visible bars, so the floating bar can show fraction complete and fraction incomplete. In addition, two line chart series are added to show milestones for completed and not-yet-completed tasks. Excel will not allow an XY series to be added to a Bar-Line combination chart, so an additional line series is used as an anchor for a vertical line and label. Using a line chart allows us to use the versatile time scale axis of the line chart as the horizontal axis of the Gantt chart. Advanced Gantt Charts in Microsoft Excel – [Peltier Technical Services]
