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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Billyd - 30 Aug 2006 21:10 GMT

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

Reply to this Message

Andy Pope - 30 Aug 2006 23:05 GMT

Hi,

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

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

Cheers
Andy

> 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

Signature

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

Reply to this Message