How to Create a Gantt Chart in Microsoft Access and Excel
written by: Misty Faucheux•edited by: Tricia Goss•updated: 8/24/2009
Gantt charts are important to project managers, but often you need some rather complicated programs in order to create them. Learn how to create a Gantt chart in Microsoft Office and Excel.
slide 1 of 3
A Gantt chart is a chart the helps project managers with project schedules. Many times you need a project management system like Microsoft Project in order to create these types of charts.However, there are ways that you can create these charts in both Microsoft Access and Excel.
In Access, one way to do this by using a software program by the name of Gantt Chart Builder System.How the Gantt Chart Builder system works is that you can color individual items in a line, allowing you to highlight features that you want to stand out to your audience.You must always have start and end dates in your data for the system to work.
With Gantt Chart Builder System, you can do the following things:
Build a chart
Delete the information on the chart
Select how you would like the presentation to display
View and/or print your chart
Export your chart as an image or to an Excel workbook
Before you start working on your chart, you need to figure out how you want your schedule broken down.It needs to be one of the following: yearly, quarterly, monthly or weekly.This will set up how your chart will look in the end.
You should download the free trial of Gantt Chart Builder System before you buy it.
Another way to create a Gantt chart is in Microsoft Excel.If you have this system, this may be the easier way of creating your chart.
slide 2 of 3
To create a Gantt chart in Excel, follow the below procedures:
1.Open a new worksheet.
2.Enter the data that you need in the cells.An example could be the following: Column A: Task, Column B: Start Date, Column C: End Date and Column D: Days Remaining.
3.Select the cells of your data.For the example, this would be cells A through D.
4.Select Chart Wizard.
5.Under Chart Type, select Bar -> Stacked Bar.
6.Click Next twice.
8.Double-click the first series of information.For the example, this would be start date.
9.Go to Patterns -> Format Data Series -> Border: None and Area: None.
11.Double-click the vertical axis.
12.Go to Scale -> Categories in Reverse order.
13.Check the provided box.
14.Double-click the horizontal axis.
15.Go to Scale.
16.Type in these dimensions: Minimum: 36739, Maximum: 37441, Major unit: 61 and Minor unit: 1.
17.Stay in Scale and select Category (X) axis crosses at maximum value.
18.Go to Alignment->Orientation.Type 45 degrees.
19.Right click the legend, and select Format Legend.