Combination Chart

[sue t]

Hello
I am working in Excel 2003, and I would like to make a
combination chart. I have 4 data series. I would like 2
of these series to be a regular column chart, and the
other 2 series to be combined (in the same chart) into a
stacked column chart. Two of the series (example value is
14 & 27) equal one of the other series which is 41. Is is
possible to combine a column chart and a stacked column
chart? Thank You

 

[Andy Pope]

Hi sue,

Take a look at Jon's example for creating clustered stacks.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy