Stacked Bar graph
 

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"

Stacked Bar graph
 

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"

Stacked Bar graph
 

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

"Bernard Liengme" wrote:

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"

Stacked Bar graph
 

Assuming x-values in A1:A12, y-values in B1:B12
select A1:B12, click Chart wizard, choose type of chart needed, etc...
Tell us specific problem
Do you know how to make charts?
See http://peltiertech.com/Excel/ChartsHowTo/index.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

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"

Stacked Bar graph
 

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" wrote:

Assuming x-values in A1:A12, y-values in B1:B12
select A1:B12, click Chart wizard, choose type of chart needed, etc...
Tell us specific problem
Do you know how to make charts?
See http://peltiertech.com/Excel/ChartsHowTo/index.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

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"

Stacked Bar graph
 

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

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

Assuming x-values in A1:A12, y-values in B1:B12
select A1:B12, click Chart wizard, choose type of chart needed, etc...
Tell us specific problem
Do you know how to make charts?
See http://peltiertech.com/Excel/ChartsHowTo/index.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

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"

Stacked Bar graph
 

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

Thanks for your help.

"Bernard Liengme" wrote:

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

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

Assuming x-values in A1:A12, y-values in B1:B12
select A1:B12, click Chart wizard, choose type of chart needed, etc...
Tell us specific problem
Do you know how to make charts?
See http://peltiertech.com/Excel/ChartsHowTo/index.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

"Bernard Liengme" wrote:

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"