On Thu, 13 Dec 2007, in microsoft.public.excel.charting,
Jim Fillpot said:

I'm curious whether I can create a combination cluster AND stacked bar
chart.

You can, but it's an exercise in lateral thinking: what does a "stacked"
bar look like when only one of the ranges has any value? Answer, it
looks just like a single cluster bar.

What does the stacked bar where every series except the "cluster" series
has a value look like? Answer, one that isn't the cluster bar.

What does a stack where *no* series has a value look like? Answer, a gap
between clusters. These three techniques together should let you build
exactly the look you want.

(for a bonus, what does a "stacked" bar where one or other series has a
value, but never both, look like? Answer, a bar that changes color
according to a formula, that is, a conditionally-formatted bar)

--
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.