software

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)

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:
gt; I've been trying to put 2 pies of comparable data (1 for men and 1 for women)
gt; on a single chart but despite trying to use the secondary access, I can't
gt; seem to get both pies (either side by side or one above the other)

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

Many thanks, Andy. I thought I had done this before, albeit some years ago
but just couldn't remember -it may even have been on Lotus 1-2-3. In Excel
today, I got as far as creating a pie on top of a column chart but couldn't
saparate them! I shall do as you suggested.

quot;Andy Popequot; wrote:

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