O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Gannt Charts

The recommended way to create a Gannt chart is with a project-management program, such as Microsoft Project. But if you must create it in Excel, you can—sort of. Figure 27-9 shows a primitive Gannt chart created in Excel.

With the Floating Bars chart type on the Custom Types tab, you can create a simple Gannt chart.

Figure 27-9. With the Floating Bars chart type on the Custom Types tab, you can create a simple Gannt chart.

This chart uses Floating Bars, an option on the Custom Types tab of the Chart Type dialog box. It plots two series—a start date and a duration. The start date is plotted as an offset from some date. Task 1, for example, begins 0 days from this reference point, Task 2 starts 4 days from the reference point, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required