Even though Microsoft Office Excel 2007 does not provide a Gantt chart type, you can simulate a Gantt chart by customizing a stacked bar chart type so that it depicts tasks, task duration, and hierarchy.
Simulated Gantt chart in Excel
Simulated Gantt chart in Excel
An Excel Gantt chart typically uses days as the unit of time along the horizontal axis. If you want to use hours instead of days, see the link in the See Also section about how to create a Gantt chart that uses hours as the scale in Excel 2007.
What do you want to do?
The following procedure will help you create a Gantt chart with results that are similar to those shown in our example Gantt chart graphic. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data, as long as you use the same column headers and worksheet structure.
Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a Gantt chart.
Note The values in columns B and C (Start and Duration) represent the number of days from the start date and the number of days required to complete the task.
Select the data that you want to plot in the Gantt chart (A1:C6 in our example worksheet data).
On the Insert tab, in the Charts group, click Bar.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
On the Design tab, in the Chart Styles group, click the chart style that you want to use.
Chart Styles group on Excel Ribbon
Chart Styles group on Excel Ribbon
Tip For our Gantt chart, we used Style 27.
In the chart, click the first data series (Start), or select it from a list of chart elements (Format tab, Current Selection group, Chart Elementsbox).
On the Format tab, in the Current Selection group, click Format Selection.
Current Selection group on Excel Ribbon
Current Selection group on Excel Ribbon
Click Fill, and then click No fill.
Click Close.
In the chart, click the legend, and then press DELETE.
Select the vertical (category) axis, or select it from a list of chart elements (Format tab, Current Selection group, Chart Elementsbox).
On the Format tab, in the Current Selection group, click Format Selection.
Under Axis Options, select the Categories in reverse order check box, and then click Close.
If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:
On the Page Layout tab, in the Themes group, click Themes.
Themes group on Excel Ribbon
Themes group on Excel Ribbon
Under Built-in, click the theme that you want to use.
Tip For our Gantt chart, we used the Office theme.
DISCLAIMER:
THIS PAGE IS MADE UNDER THE SPECIFICATIONS OF THE COMPUTE THIS 2011-2012 RULES. FOR INFORMATION OR ADDITIONAL HELP, REFER TO http://www.scioly.org/phpBB3/index.php OR TO http://soinc.org/ . ALL CHART TUTORIALS ARE FROM THE http://www.microsoft.com/en-us/default.aspx DOMAIN. ALL CHARTS ARE FROM EXAMPLES REMADE BY STUDENTS IN THE PROGRAM. PLEASE NOTE THAT INFORMATION ON THIS SITE MAY BE SUBJECT TO COPYWRITE THAT IS NOT OWNED BY SCIENCE OLYMPIAD OR WIKISPACES. COPY INFORMATION AT YOUR OWN DISCRETION. THANK YOU.
Even though Microsoft Office Excel 2007 does not provide a Gantt chart type, you can simulate a Gantt chart by customizing a stacked bar chart type so that it depicts tasks, task duration, and hierarchy.
An Excel Gantt chart typically uses days as the unit of time along the horizontal axis. If you want to use hours instead of days, see the link in the See Also section about how to create a Gantt chart that uses hours as the scale in Excel 2007.
What do you want to do?
Simulate a Gantt chart
The following procedure will help you create a Gantt chart with results that are similar to those shown in our example Gantt chart graphic. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data, as long as you use the same column headers and worksheet structure.- Create a blank workbook or worksheet.
- Select the example in the Help topic.
Note Do not select the row or column headers.Selecting an example from Help
Note The values in columns B and C (Start and Duration) represent the number of days from the start date and the number of days required to complete the task.
- Select the data that you want to plot in the Gantt chart (A1:C6 in our example worksheet data).
- On the Insert tab, in the Charts group, click Bar.
- Under 2-D Bar, click Stacked Bar.
- Click the chart area (chart area: The entire chart and all its elements.) of the chart.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.Tip For our Gantt chart, we used Style 27.
- Under Built-in, click the theme that you want to use.
Tip For our Gantt chart, we used the Office theme.DISCLAIMER:
THIS PAGE IS MADE UNDER THE SPECIFICATIONS OF THE COMPUTE THIS 2011-2012 RULES. FOR INFORMATION OR ADDITIONAL HELP, REFER TO
http://www.scioly.org/phpBB3/index.php OR TO http://soinc.org/ . ALL CHART TUTORIALS ARE FROM THE http://www.microsoft.com/en-us/default.aspx DOMAIN. ALL CHARTS ARE FROM EXAMPLES REMADE BY STUDENTS IN THE PROGRAM. PLEASE NOTE THAT INFORMATION ON THIS SITE MAY BE SUBJECT TO COPYWRITE THAT IS NOT OWNED BY SCIENCE OLYMPIAD OR WIKISPACES. COPY INFORMATION AT YOUR OWN DISCRETION. THANK YOU.