Power Point Charts

[Guest]

I am trying to create a cluster chart for a 5-year period, where the x-axis
is the year and the y-axis represents a sales dollar value. There are two
sets of data for each year (hence a two-column cluster chart). However, the
second of the two columns for each year incorporates two types of sales data,
and thus I need to stack the two data points to show the breakout between the
two types of sales data. The height of this second column should be the
combined value of the two sets of sales data, but I need to stack them so
that I can color them differently in order to view the two separate pieces
that make up the whole.

Is it possible to create a cluster chart where one of the columns is stacked?

Please help. I have tried everything I know within Power Point to try to
find a way.

Thanks. WBL

 

[Bill Dilworth]

This can be accomplished by using two overlaid charts and some creative
patience. The key is to make as much of the charts non-data invisible as is
possible, the resultant 2 charts can have the gaps and depth adjust to fit
seamlessly together to appear as a single cart with clustered bars of which
one is segmented.

Not an easy solution, but I don't think one exists.


--
Bill Dilworth
Microsoft PPT MVP Team
Users helping fellow users.
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of your questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..

 

[Andy Pope]

Hi,

I have some info on cluster/stacked charts using MSGraph.
http://www.andypope.info/ngs/ng28.htm

Cheers
Andy