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

  • Thread starter Thread starter g
  • Start date Start date
G

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?
 
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?
Click to expand...

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