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

[g]

Hi 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?

 

[Del Cotter]

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.

 

[Jon Peltier]

Here's an illustrated tutorial:
http://peltiertech.com/WordPress/2008/05/19/clustered-stacked-column-charts/

- Jon