3 pie charts

[Ginger]

Hi,

How do i create 3 pie charts (instead of bar chart) using
the following data:-

A B C
2000 10 20 15
2001 20 15 18
2002 15 20 20

I'm creating the pie charts one by one. As a result, I
have 3 frames. However, I would like to have all the pie-
charts in one frame.

Can someone pls help?

Thanks.

 

[Frank Kabel]

Hi
maybe try:
http://andypope.info/charts/pies.htm

 

[Andy Pope]

Hi,

The simplest way to do this is to use a blank chart sheet to hold 3
other chart objects.
Create the 3 charts on a worksheet as normal.
The with the activecell away from any data press F11. This will create a
blank chart sheet. You can now go to each of the chartobjects in turn
and change their Location from object on sheet to object on chartsheet.

To remove the border from around each pie chart double click the chart
and set border to none. You may may to remove the legend from 2 of the
charts depending.

Cheers
Andy

 

[Ginger]

Thank you, gentlemen.

Glad to find out this feature.