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?

On Wed, 6 Aug 2008, in microsoft.public.excel.charting,
g 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 ,
which goes to a spam folder-- please send your email to del3 instead.

Here's an illustrated tutorial:
http://peltiertech.com/WordPress/200...column-charts/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"g" wrote in message
...
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?