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

A

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Multiple pies of pie 1
Best way to create a chart w/ xy axis, quartile circles and point plots? 2
how to display multiple charts on a single chart sheet 1
Multiple columns over a chart 0
Excel Chart Display Order 1
automatically change number of bars in bar chart 0
Is it possible to resize chart itself (not chart area) 4

Top