Dual colors on same Bar?

W

WOODY

I have a bar graph showing different organizations projected costs for the
year. I need to setup a stacked bar for each organization with beginning of
the year projected costs and up to date projected costs.

Example: $10,000 for Organization A - 1 bar (cell) currently with $10,000,
new bar needs to be $7200 for (beginning of the year projection) and $10,000
(up to date prjection) still contained in 1 bar graph in the stack format as
$7200 will be a different color or pattern from $10,000.

Can this be done??
 
W

WOODY

Echo - Would there be any way to setup my chart as a combination of a stacked
and regular bar chart? I have 2 bars for each organization 1 bar needs two
stacked on each other like I referred to in my first post and there needs to
be another bar right beside it that is just a solid bar.

Example - Organization A needs a bar that has (money requested start of
year, and updated money requested) stacked on top of each other. Then beside
it for Organization A I need a bar that has just Money granted.

I have 10 organizations to do this for.

Any help would be appreciated. If you need to see my chart to figure out
what I am talking about I can email it to you.

Thanks for the Help!!

Echo S said:
Yes. Just choose Stacked Bar Chart in the chart type dialog.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


WOODY said:
I have a bar graph showing different organizations projected costs for the
year. I need to setup a stacked bar for each organization with beginning
of
the year projected costs and up to date projected costs.

Example: $10,000 for Organization A - 1 bar (cell) currently with $10,000,
new bar needs to be $7200 for (beginning of the year projection) and
$10,000
(up to date prjection) still contained in 1 bar graph in the stack format
as
$7200 will be a different color or pattern from $10,000.

Can this be done??
 
E

Echo S

Well, that's different.

You have to arrange your data. See this:
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


WOODY said:
Echo - Would there be any way to setup my chart as a combination of a
stacked
and regular bar chart? I have 2 bars for each organization 1 bar needs two
stacked on each other like I referred to in my first post and there needs
to
be another bar right beside it that is just a solid bar.

Example - Organization A needs a bar that has (money requested start of
year, and updated money requested) stacked on top of each other. Then
beside
it for Organization A I need a bar that has just Money granted.

I have 10 organizations to do this for.

Any help would be appreciated. If you need to see my chart to figure out
what I am talking about I can email it to you.

Thanks for the Help!!

Echo S said:
Yes. Just choose Stacked Bar Chart in the chart type dialog.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


WOODY said:
I have a bar graph showing different organizations projected costs for
the
year. I need to setup a stacked bar for each organization with
beginning
of
the year projected costs and up to date projected costs.

Example: $10,000 for Organization A - 1 bar (cell) currently with
$10,000,
new bar needs to be $7200 for (beginning of the year projection) and
$10,000
(up to date prjection) still contained in 1 bar graph in the stack
format
as
$7200 will be a different color or pattern from $10,000.

Can this be done??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top