Looking for a little help creating a Gantt Chart? Use the Gantt Chart Wizard to end up with the chart you want.
Before you start, you’ll need to add the Gantt Chart Wizard to the Project ribbon.
I would like to prepare a Gantt graph using Microsoft Access 2007. I thought about using 'Pivot Charts' but any other idea would be fine. I have here a picture of what I have in mind, done with Excel.
Click File > Options > Customize Ribbon.
In the right column, click the tab you want to add the Gantt Chart Wizard to (for example, View), and then click New Group.
To give your new group a name (for example, Wizards), click New Group (Custom), click Rename, type your new name, and then click OK.
In the left column, click the arrow under Choose commands from, and then click Commands Not in the Ribbon.
Page down in the left column, and then click Gantt Chart Wizard. Highlight the new group you created in step 2 (it’s in the right column), click Add, and then click OK.
Click the tab where you put the wizard (in this example, we used the View tab), and then click Gantt Chart Wizard. Follow the steps to create your new chart.
A Gantt chart helps you schedule your project tasks and then helps you track your progress.
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can create one using this free template: Gantt project planner template for Excel
Need to show status for a simple project schedule with a Gantt chart? Though Excel doesn’t have a predefined Gantt chart type, you can simulate one by customizing a stacked bar chart to show the start and finish dates of tasks, like this:
To create a Gantt chart like the one in our example that shows task progress in days:
Select the data you want to chart. In our example, that’s A1:C6
If your data’s in a continuous range of cells, select any cell in that range to include all the data in that range.
If your data isn't in a continuous range, select the cells while holding down the COMMAND key.
Tip: If you don't want to include specific rows or columns of data you can hide them on the worksheet. Find out more about selecting data for your chart.
Click Insert > Insert Bar Chart > Stacked Bar chart.
Next, we’ll format the stacked bar chart to appear like a Gantt chart. In the chart, click the first data series (the Start part of the bar in blue) and then on the Format tab, select Shape Fill > No Fill.
If you don’t need the legend or chart title, click it and press DELETE.
Let’s also reverse the task order so that it starts with Task1. Hold the CONTROL key, and select the vertical axis (Tasks). Select Format Axis, and under Axis Position, choose Categories in reverse order.
Customize your chart
Interactive Gantt Chart For Microsoft Access
You can customize the Gantt type chart we created by adding gridlines, labels, changing the bar color, and more.
To add elements to the chart, click the chart area, and on the Chart Design tab, select Add Chart Element.
To select a layout, click Quick Layout.
To fine-tune the design, tab through the design options and select one.
To change the colors for the chart, click Change Colors.
To reuse your customized Gantt chart, save it as a template. Hold CONTROL and click in the chart, and then select Save as Template.
Did you know?
If you don't have an Office 365 subscription or the latest Office version, you can try it now: