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!

 

Duncan Williamson

One Response to “Resource Histogram”


  1. […] you can see this histogram shows ranges of baby lamb birth weights in New-Zealand (please do not take the values too seriously […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: