Multiple Pies in One chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to show multiple pies in one chart? I tried first formatting the data as two sets of columns and then changing the chart type for each set. This indeed gave me two pies -- but they are right on top of one another, so you can't see them both.

Any other thoughts?

Thanks.
 
Use a pie-in-pie chart, if it is appropriate, or a doughnut chart with
the hole shrunk as much as possible, or create two separate charts and
position and format them so that they look like one.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Greg -

If you just want to show two pies side by side, make two pie charts, and
put them side by side.

- Jon
 
Hi Greg

It is possible to put 2 (or more) charts in the chart area of a singl
chart sheet, which I often find useful, as it behaves much the same a
a single chart for printing, linking etc. As pies are so often used fo
side-by-side comparisons, you'd think they would build this in as
standard chart.

The attached chartsheet has 2 pies on

Attachment filename: two pies.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=41208
 
Back
Top