Displaying a Project's Resource Histogram Views in MS Project 2007

Page content

Click here to read part one of this two part series.

Resource Graph

A great histogram view can be found in the Resource Graph. This view is shown in Figure 3 and is easily accessible from both the View bar and the View menu. When you display the Resource Graph view, you will see allocated work hours for an individual resource. The best part of Resource Graph view lies in your ability to quickly see which resources are allocated so you can make scheduling adjustments.

On the Resource Graph, overscheduled resources are displayed on the left in red text with associated red graph bars on the right. Plus, the Resource Graph has a modifiable timescale with three tiers at the top. To modify the timescale, just double-click it. Alternatively, you can right-click the timescale and choose Timescale from the shortcut menu. Both of these methods allow you to access the Timescale dialog box where you can modify each of the three timescale tiers and their display.

New Resource Graph users sometimes find the Resource Graph view to be slightly overwhelming. The bars are big and it can take an eon to locate overallocations. But, once you get your bearings, the Resource Graph is a very handy histogram. First, use the lower left horizontal scroll bar to locate a resource printed in red text. The red print indicates an overallocated resource. Then, once you’ve located a resource that has been overallocated, click the Go to Next Overallocation button (found on the Resource Management toolbar).

Once you get the hang of it, you’ll probably discover that the Resource Graph is the traditional histogram view showing resource allocation, cost, and the work over time.

Resource Sheet

The Resource Sheet is one of the most common views for working with your project’s resources. Although the Resource Sheet does not offer any scheduling information (beyond displaying an overallocated resource in red), it is the one place you can go to enter all of your pertinent resource data such as pay rates and calendar information. A sample resource sheet is shown in Figure 4. You can display the Resource Sheet from either the View bar or the View menu. Because it’s such a common view, it’s readily accessible from a couple of different locations.

Resource Usage

Also displaying data against a timescale backdrop is the Resource Usage view. A sample Resource Usage view is shown in Figure 5. You can display the Resource Usage view by using the related icon on the View bar or by choosing View: Resource Usage from the Menu bar.

The best thing about the Resource Usage view is its ability to display a variety of data beyond the default Work values. In addition to Work values, you can customize this view to show:

  • Actual Work
  • Cumulative Work
  • Overallocation
  • Cost
  • Remaining Availability

Any of this additional data can be added to the Resource Usage view by right-clicking any value in the Details column (usually says “Work”), and then choosing the data you want to display from the shortcut menu.

You may have noticed as you read through this series on displaying the Resource Histogram in Project 2007 that there actually is no view called the “Resource Histogram.” But, the Resource Graph comes closest to the histogram in the traditional sense. As an aside – there is no “PERT Chart” in Project, either. It’s called the Network Diagram.

Click here to read part one of this two part series.

This post is part of the series: Project 2007: How to Display the Resource Histogram

Use Project 2007 to display the Resource Histogram and other related resource management views.

  1. Project 2007: How to Display the Resource Histogram (Part 1 of 2)
  2. Project 2007: How to Display the Resource Histogram (Part 2 of 2)