Stacked Bar graph

[Guest]

Hello,
I need help to create a stacked graph by resource each month in Percentage.
Which mean the x-axis is months and y-axis is percentage and the series are
Resources (people)

It tells us how much total work each resource is doing by month. Now the
problem is, within these bar charts by resources I want to stack the % of
projects these resources are working on....Ex. john is working 65% in Feb06,
out of which 30% of the work is project A and 25% is project B and 10% is
project C. Can you tell me how can i graph the project distribution within
the resources by month.

I have tried many ways but can't get the answer and I don't know VBA. All
your help and time are
greatly appreciated.

Thanks"

 

[Bernard Liengme]

You will need columns converting your numbers to percentages.
If the numbers are in B2:B10, use for B2's value =B2/SUM($B$2:$B$10)
best wishes

 

[Guest]

Sorry but I need to know how to graph this information. i have already
converted the numbers to percentages and now I need to graph it...

Thanks

 

[Guest]

Hello Bernard
Well I drived the following information from project to excel and now I need
to graph this...
There are 4 projects with 3people working on it for lets say 4months.
following is the data

2/1/2006 3/1/2006 4/1/2006 5/1/2006
Resource1
JOHN 53.2% 64.1% 76.6% 90.9%
Project 1 14.4% 21.6% 34.1% 48.4%
Project 2 10.6% 16.3% 16.3% 16.3%
Project 3 14.1% 13.1% 13.1% 13.1%
Project 4 14.1% 13.1% 13.1% 13..1%
Resource2
MARY 72.5% 55.9% 55.9% 55.9%
Project 1 5.6% 2.8% 2.8% 2.8%
Project 2 13.8% 15.0% 15.0% 15.0%
Project 3 26.6% 19.1% 19.1% 19.1%
Project 4 26.6% 19.1% 19.1% 19.1%
Resource3
POOJA 37.6% 46.3% 46.3% 46.3%
Project 1 8.1% 4.1% 4.1% 4.1%
Project 2 9.1% 11.6% 11.6% 11.6%
Project 3 10.2% 15.3% 15.3% 15.3%
Project 4 10.2% 15.3% 15.3% 15.3%

Now I need to graph this by resource by month and how much these resources
are doing on these projects.
Thanks for your time and all the help

 

[Bernard Liengme]

See http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm
Send me a private message (so I can send you a file) and I will try to find
time to make the chart for you

 

[Guest]

Hello Bernard..
I can't see your emai. can you please provide me your email again.....

Thanks for your help.