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.
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!
Duncan Williamson
10 10 2014 at 7:49 am
[…] you can see this histogram shows ranges of baby lamb birth weights in New-Zealand (please do not take the values too seriously […]