Micorosoft 2000 chart options

[Andrew]

Does anyone know how to combine a Cluster Column Chart
with a Stacked Column Chart? I want to have a stacked
column chart of two group's performances for the month,
compared with the two groups total plan for the month
(cluster column).

 

[Jon Peltier]

Andrew -

You can make a clustered stacked column chart through clever arrangement
of your data in the worksheet. See the details at Stephen Bullen's site:
http://www.bmsltd.co.uk/Excel/SBXLPage.asp#Charting
and look at the description for FunChart4

or at Bernard Liengme's site:
http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm

- Jon