Stacked Bar graph

Pooja · 03-03-2006, 12:45 PM

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 · 03-03-2006, 01:30 PM

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" <Pooja@discussions.microsoft.com> wrote in message
news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
> 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"
>

Pooja · 03-03-2006, 02:10 PM

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" <Pooja@discussions.microsoft.com> wrote in message
> news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
> > 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 · 03-03-2006, 02:20 PM

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" <Pooja@discussions.microsoft.com> wrote in message
news:C0C98BCA-FFD7-4491-81E7-54F5A57BCDAA@microsoft.com...
> 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" <Pooja@discussions.microsoft.com> wrote in message
>> news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
>> > 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"
>> >
>>
>>
>>

Pooja · 03-03-2006, 02:40 PM

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" <Pooja@discussions.microsoft.com> wrote in message
> news:C0C98BCA-FFD7-4491-81E7-54F5A57BCDAA@microsoft.com...
> > 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" <Pooja@discussions.microsoft.com> wrote in message
> >> news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
> >> > 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 · 03-04-2006, 03:20 PM

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" <Pooja@discussions.microsoft.com> wrote in message
news:5453243B-6B1E-4187-907C-998DD3259CFD@microsoft.com...
> 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" <Pooja@discussions.microsoft.com> wrote in message
>> news:C0C98BCA-FFD7-4491-81E7-54F5A57BCDAA@microsoft.com...
>> > 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" <Pooja@discussions.microsoft.com> wrote in message
>> >> news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
>> >> > 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"
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Pooja · 03-06-2006, 11:35 AM

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" <Pooja@discussions.microsoft.com> wrote in message
> news:5453243B-6B1E-4187-907C-998DD3259CFD@microsoft.com...
> > 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" <Pooja@discussions.microsoft.com> wrote in message
> >> news:C0C98BCA-FFD7-4491-81E7-54F5A57BCDAA@microsoft.com...
> >> > 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" <Pooja@discussions.microsoft.com> wrote in message
> >> >> news:7AE27C12-EA91-45BD-9650-C16D9F2F4E87@microsoft.com...
> >> >> > 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"
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>