Hi,
The pie chart will not produce two separate pies within a single chart.
In order to do this you will need to create 2 separate chartobjects and
either arrange them on the worksheet or embed them within an empty chart
sheet. To create an empty chart sheet just place cursor in an empty area
of the worksheet and press F11. To embed chart objects within the chart
sheet right click chart object and pick Location. From the embedded list
choose the chart sheet.
Cheers
Andy
tartanspice wrote:
I've been trying to put 2 pies of comparable data (1 for men and 1 for women)
on a single chart but despite trying to use the secondary access, I can't
seem to get both pies (either side by side or one above the other)
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info