is there a way to create multiple pies in one chart (comparison)?

[Jim W]

[Andy Pope]

Hi,

Quick answer is no.
Create multiple chart objects and arrange then to appear as 1 chart. So
only display the legend on one of the chartobjects and either use cells
to draw a border around the charts or add a rectangle.

If you need to you can then change there location to embed the chart
objects within a blank chart sheet. A quick way to create a blank chart
sheet is to press F11 making sure the active and surrounding cells are
empty.

Cheers
Andy

Jim W wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info