setting the radius of a pie chart
 

is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?

i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.

Hi anson,

You will need some code to help with this.
Have a look at the example.
http://www.andypope.info/ngs/ng34.htm

Cheers
Andy

anson wrote:
is there a way of setting the radius or the area of a pie chart in excel, in
centimetres or some other equivalent?

i am asking this as i need to create a series of pie charts that are
proportional to the amount of data that is in them.

--

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