On Fri, 24 Aug 2007, in microsoft.public.excel.charting,
Lambi000 said:
I have a bar chart that shows 8 weeks of data, with the weeks being the X
axis; the Y is the amount. There are three bars: total opened this week,
total closed this week and total still open for the year. I have a breakdown
by business unit for the total still open for the year which my boss wants
represented by a stacked bar.

My question is: Can I incorporate ONE stacked bar into this chart? The
other two bars have no breakdown and don't need one. I can't think of a way
to do this.

Have each stacked bar contain n+1 series, where n is the number of
business units, and the +1 is the total over all business units. Then
have n of the series contain data for the business unit for one column
and =NA() for the total for two columns, while the last series contains
=NA() for one column and the total data for two columns.


The data block should then look like this:

Col1 Col2 Col3
BU001 999 #N/A #N/A
BU002 999 #N/A #N/A
BU003 999 #N/A #N/A
BU004 999 #N/A #N/A
Total #N/A 999 999

where "999" is whatever numbers you have. Column 1 will look like a
stacked bar, and columns 2 and 3 will be stacked bars, but won't look
like it because all the blocks in the stack but one will be invisible.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.