Create Custom Tables and Custom Views in MS Project

Share on FacebookTweet about this on TwitterShare on LinkedInBuffer this pageEmail this to someone
Microsoft Project Tutorial: Learn how to create custom tables and custom views

The number of views into Microsoft Project’s scheduling data can be overwhelming. The delivered views on the Microsoft Project view bar include the Gantt chart, resource usage, task usage, and resource graph views. When you combine these views with the entry, cost, tracking, and variance tables, it can get confusing.

Novice project managers remedy this problem by adding every column of data that they’ll ever need into the Gantt chart view. The end result is there are too many columns in one view, and it creates information overload. It quickly becomes difficult to navigate, print, and manage the project data . (I’ve inherited project schedules that had more than 20 columns in a single Gantt chart view.)

One solution is to create a custom view that provides the core schedule data needed to define, track, and update your project schedule. For the past few years, I’ve been using a custom view called myGantt that provides all the data I need to update project progress and track the project schedule (Figure 1)

Create Custom Tables and Views in MS Project

Figure 1 – myGantt View

You can create your own myGantt view by following these steps using the delivered entry and tracking tables.

Create a set of custom tables and custom views

By creating custom tables and views, you’ll import the same data and still be able to switch back to the delivered Gantt chart and standard tables. If you don’t create a separate set of tables and views, any changes you make to the underlying tables will affect the standard views in Microsoft Project.

  1. Go to View | Tables | More Tables and select the Entry table.
  2. Click Copy and rename the table to myEntry (Figure 2).
  3. Click the OK button.
Create Custom Tables and Views in MS Project 2

Figure 2 – Table Definition

Create a custom myTracking table

  1. Repeat steps 1-3 from the previous section and use the Tracking table.
  2. Edit the table to include these fields: Name, Actual Start, Actual Finish, Baseline Start, Baseline Finish, % Complete, Actual Duration, Remaining Duration, Baseline Duration. If you’re tracking effort-driven tasks, you should include Actual Work and Baseline Work fields.
  3. Click the OK button.

Create a custom myEntry view

  1. Go to View | More Views.
  2. In the View Definition dialog box, enter myEntry for the Name, select the myEntry Table, set the Group to No Group, and set the Filter to All Tasks. Click the OK button. (Figure 3)
Custom Tables and View MS Project 3

Figure 3 – View Definition

Create a custom myTracking view

  1. Repeat the steps above and use the myTracking view.

Create a myGantt combination view

The combination view splits the Microsoft Project workspace into two panels; this allows you to see the entry and the tracking data all in one view.

  1. Go to View | More Views | New.
  2. Enter myGantt for the Name and select myEntry for the Top view and myTracking for the Bottom Views Displayed (Figure 4).
Custom Tables and Views MS Project 4

Figure 4 – MyGantt View Definition

  1. Click the Show In Menu checkbox.
  2. Click the OK button.

Test your view

By clicking the Show In Menu checkbox, you should see the myGantt view in your View Bar and in your View menu.

  1. Go to Click On View | myGantt. The myGantt view from Figure B will be displayed.

With this view, you can click on one task in the upper window pane and view all the relevant tracking data in the lower pane. By highlighting multiple tasks, you’ll receive all the key information you need to track your schedule.

Why use custom views and tables in MS Project?

The key benefit of this myGantt view is the amount of time you’ll save switching between different views and inserting or hiding different columns. With one combination view, the project manager is able to view the baseline dates, the actual dates, and the impact of those dates to the forecasted schedule. Using this single combination view, you can record the actual duration and the remaining duration to generate an objective percent complete. The supporting Gantt chart can still be formatted to view the critical path or other Gantt chart wizard graph charts. You can also change the upper and lower window panes based on the tracking or the resource utilization needs. Since you created custom objects, you can easily revert to the original views by clicking the Gantt chart icon and removing the split view.

You can change the upper and lower window panes based on the tracking or the resource utilization needs. Since you created custom objects, you can easily revert to the original views by clicking the Gantt chart icon and removing the split view.

About Andrew Makar

Professional Cat Herder and an Agile Enthusiast with a keen interest in putting PM theory into actual practice.
No comments yet.

Leave a Reply