How do I set the scale of one pie chart to another chart
 

I would like to scale several pis charts in comparison to one of the charts.
ie say one pie chart represents 500 total items then the second chart which
has 250 item would be half the size of the first chart and so on. I'm using
excel 2003

How do I set the scale of one pie chart to another chart
 

Hi,

This should help.
http://www.andypope.info/charts/piesizer.htm

"pis charts", nice Freudian slip on the chart type ;)

Cheers
Andy

Billyd wrote:
I would like to scale several pis charts in comparison to one of the charts.
ie say one pie chart represents 500 total items then the second chart which
has 250 item would be half the size of the first chart and so on. I'm using
excel 2003

--

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