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?:
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.
To Draw the Resource Histogram
- Select the whole table
- 2-D Stacked Column
That’s really all there is to it!