Excel 2007 : Stacked Percent Column Chart

Surely this can't be that hard...I want to create a stacked bar or column chart showing how projects contribute to overall demand by month. Time is expressed in hours in the example below. Meaning in January, Project 1 is consuming roughly 11% of the labor, Project 2, 18%, and Project 3, 71% .

Data looks like this:

Project Name Jan Feb Mar Apr May
Project 1 3 3 3 3 3
Project 2 5 4 2 7 9
Project 3 20 25 30 15 20

Originally Posted by Andy Pope

Sort of depend what you tried.

You can either use the 100% stack or calculate the percentages and use stacked.

Thanks! Exactly what I needed!