Can I create a bar graph with both stacked and normal bars?

On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
g <g.RemoveThis@discussions.microsoft.com> said:
>I'm trying to create a bar chart for my company for turnover against
>targets. For the targets we want fixed bars, however on the turnover we
>wanted the same bars made up different colours, so the colours highlight
>where the turnover came from (therefore stacked). Can I have some bars fixed
>and some stacked on a chart please?

Just have your stacked bars include all the data columns, whether
stacked or not, then your "stacked" bars can have real values for the
stacked values, and blank values for the unstacked; while the
"unstacked" bars will only have real values for the unstacked
quantities, and all the stacked cells will be blanks.

Now you can't have clusters of bars using the "Options" tab, so you have
to include blank rows where there are no values at all, to provide a gap
between groups of bars.

--
Del Cotter
NB Personal replies to this post will send email to del.RemoveThis@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.