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

2 Responses 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 […]

  2. […] Download Image More @ excelmaster.co […]

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: