Excel Gantt Charts Generator and Project Estimator for IT Project Managers. We help you to create IT Project Plans. AUTOMATICALLY. Want to create a Project Plan together with an accurate estimatiion in just a few clicks? Our innovative approach allows to define a Plan starting from the PM effort you think might be necessary on a weekly basis, knowing that such effort will manage the 80% of the overall budget. The longer the elapsed, the more accurate this mathematical relationship is and the easier is the creation of an IT Project Plan. And for the experienced user, many more estimation templates are natively available.
- 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.
I was recently reading the latest posts in the Project Standard and Professional user forum, when I found a recent reply to a question that was originally posted in March 2011. I was greatly amused that anyone would reply to a post that was so old and that was marked as answered so long ago. Out of curiosity, I read this most recent reply, and was hit by a “blast out of the past” as I read it.
The original question was how to hide the resource names that are displayed at the right end of the Gantt bars shown in the default Gantt Chart view. This question and several follow up questions were all answered successfully back in 2011. The user who posted the most recently reply, however, offered another way to hide those resource names: use the Gantt Chart Wizard.
Truth be known, I have not thought about the Gantt Chart Wizard for at least a decade, if not longer than that. In fact, as an aside, the Gantt Chart Wizard was documented in the first book in which I was a co-author (technically a contributing author), which was the Special Edition: Using Microsoft Project 2002 book, published by Que Publishing.
The user’s recent reply made me wonder whether the Gantt Chart Wizard is still available in Microsoft Project 2019. Sure enough, I looked for myself, and this tool is still available.
By the way, the Gantt Chart Wizard is a useful little tool for formatting the Gantt Chart pane in any Gantt-based view. For example, did you know the Tracking Gantt view is simply a specially formatted version of the default Gantt Chart view? Using the Gantt Chart Wizard can be a time saver if you want to create your own custom Gantt-based view with a customized Gantt Chart pane.
Accessing the Gantt Chart Wizard
To access the Gantt Chart Wizard, you will need to add this command to your Quick Access Toolbar by completing the following steps in Microsoft Project:
- Click the File tab and then click the Options tab in the Backstage.
- In the Project Options dialog, click the Quick Access Toolbar Microsoft Project displays the Customize the Quick Access Toolbar page of the dialog, such as shown in Figure 1.
3. On the Customize the Quick Access Toolbar page, do the following, as indicated in Figure 1 shown previously:
- In the upper-left corner of the dialog, click the Choose commands from pick list and select the All Commands
- In the list of available commands on the left side of the dialog, select the Gantt Chart Wizard
- In the list of commands on the right side of the dialog, select the command after which you want the new command to be added to your Quick Access Toolbar. Notice in Figure 1 that I want to add the command at the bottom of all commands on my Quick Access Toolbar, after the <Separator>
- Click the Add >> button in the middle of the dialog.
4. Click the OK button to close the Project Options dialog.
Using the Gantt Chart Wizard
To use the Gantt Chart Wizard tool, open a project in which you want to customize the Gantt Chart pane, preferably of a custom view you are creating, and then click the Gantt Chart Wizard button on your Quick Access Toolbar. Microsoft Project displays the Welcome page of the Gantt Chart Wizard dialog shown in Figure 2.
In the Gantt Chart Wizard dialog, click the Next > button. The Gantt Chart Wizard dialog displays a page that allows you to customize the information you want to display in the Gantt Chart view, such as shown in Figure 3. Select the Standard option to display the default formatting of the Gantt Chart. Select the Critical Path option to display Critical tasks using red Gantt bars and non-Critical tasks using blue Gantt bars. Select the Baseline option to format the Gantt Chart using the formatting in default Tracking Gantt view. Select the Other option and then you can choose one of 13 sets of standard formatting options for the Gantt Chart. You can also select the Custom Gantt Chart option and the wizard will walk you through a series of dialogs in which you select the exact set details you want to display in the Gantt Chart.
Select your option on the page and then click the Next > button. If you selected any option other than the Custom Gantt Chart option, the Gantt Chart Wizard displays a page which allows you to select the information that appears with each Gantt bar, such as shown in Figure 4. Select the Resources and dates option to display resource names to the right of the Gantt bars for detailed tasks, and Finish dates to the right of milestones. Select the Resources option to display resource names only for detailed tasks and no information for milestones. Select the Dates option to display Finish dates for both detailed tasks and milestones. Select the None option to omit resource names from detailed tasks and Finish dates from milestones. If you select the Custom task information option, the Gantt Chart Wizard will display a page that allows you to select which fields you want to display to the left, to the right, and inside of every Gantt bar for both detailed tasks and milestones.
Select your option on the page and then click the Next > button. If you selected any option other than the Custom task information option, the Gantt Chart Wizard displays a page in which you can choose whether to display link lines between Gantt bars, such as shown in Figure 5. On this page, the default option is Yes, which automatically displays link lines between dependent tasks. You can select the No option, which will not display any link lines between dependent tasks in the project.
Select your option on the page and then click the Next > button. The Gantt Chart Wizard displays the Congratulations page shown in Figure 6.
On the Congratulations page, click the Format It button to format the Gantt Chart according to your specifications. After the Gantt Chart Wizard finishes its formatting operation, it displays the Finished page shown in Figure 7. On the Finished page of the dialog, click the Exit Wizard button to close the dialog.
Before I wrap up this blog post article, let’s go back for a moment to the page in the Gantt Chart Wizard dialog that allows you to customize the information you want to display in the Gantt Chart view, shown previously in Figure 3. What happens if you select the Custom Gantt Chart option? The Gantt Chart Wizard displays a series of pages that allow you to specify every option for formatting the Gantt Chart pane. Specifically, these pages allow you to specify the following:
- Do you want to display the Critical Path in the Gantt Chart?
- If yes, what color and formatting do you want to use for the Gantt bars for Critical tasks?
- What color and formatting do you want to use for the Gantt bars for non-Critical tasks?
- What color and formatting do you want to use for the Gantt bars for summary tasks?
- What color and formatting do you want to use for the Gantt bars for milestone tasks?
- Do you want to display a second set of Gantt bars, such as to show the Baseline schedule, to show the Total Slack for each task, or to show both the Baseline schedule and the Total Slack?
- What information to you want to display to the right of each Gantt bar for detailed tasks, summary tasks, and milestones, such as resource names and Finish dates?
- Do you want to display link lines between dependent tasks?
From the list of pages that the Gantt Chart Wizard displays, you can see that the wizard gives you total control over how you want your Gantt Chart pane to be formatted. When finished with applying these custom settings, the Gantt Chart Wizard displays the Congratulations page shown previously in Figure 6. And when you click the Format It button on the Congratulations page, it displays the Finished page shown previously in Figure 7.
Warning: Keep in mind that if you use the Gantt Chart Wizard to format your Gantt Chart, Microsoft Project will format your Gantt bars according to the styles, colors, and symbols used Microsoft Project 2010 and early versions of the software, and not the way the Gantt Chart view appears in current versions of the software. For example, if you select the Standard display of the Gantt Chart, the software will format the Gantt bars with a darker blue color rather than the light blue color used in Microsoft Project 2013, 2016, and 2019. You can see these old darker blue Gantt bar colors in the dialog shown in Figure 3. Because of this, you may not want to use the Gantt Chart Wizard to format your Gantt Charts.