Combination with Column & Stacked Column

[James]

Is it possible to create a combination chart with column
and stacked column groupings? For each month, I would
like to compare total expected vacation time-off (columns)
with actual vacations (stacked column showing annual
vacations, special vacations, leiu days, etc.).

I can combine the stacked columns with lines, points, or
areas, but I would like to compare columns side by side.
Is there a way? Thanks.

 

[Jon Peltier]

James -

You can fake it by making a stacked column chart of carefully arranged
data. There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

which is based on the example on Stephen Bullen's web site:
http://www.bmsltd.co.uk/Excel/Default.htm
Go to Charting Examples, and download FunChart4.xls

- Jon