View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Can I create a bar graph with both stacked and normal bars?

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?