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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pooja" wrote in message
...
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"