Resource Histogram

I have to confess that I had never heard the phrase Resource Histogram before last night. A colleague asked me if I could show him how to prepare one of those histograms in Excel. I asked him to show me an example and I would do what I could. Well, here is the chart I was given and of course, that is NOT a histogram at all but it is what I was given and how to prepare it?:

image

What I did was to create a table of data from the chart I was given then ask Excel to create a Stacked Column Chart. That’s it apart from adding chart titles and an axis label and so on. Here is the table of data I put together and on which the above Resource Histogram is based.

Task Jan Feb Mar Apr May Jun
Managers 1 1 1 1 1 1
Business Analysts 2 2 2 1 1 1
Programmers 1 1 4 4 4 1
Technical Writers 0 0 0 1 1 1

 

To Draw the Resource Histogram

  • Select the whole table
  • Insert
  • Charts
  • Column
  • 2-D Stacked Column

That’s really all there is to it!