Hi Denise,

The chart function does not allow to have both stacking and group of data.

This effect can be achieved by careful arrangement of the source data. See
the FunChrt4.zip file on my web site (www.oaltd.co.uk/Excel) for an example.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev