Multiple pie charts on one sheet, scaling pie charts according to sample size.

[nrschmid]

I am using Excel 2002. I am using a frequency spreadsheet with each cell equaling a number of occrances. Rows measure one variable, columns measure another variable.

This is what I am trying to do:

(1) Create pie charts on the same page, with each pie chart representing a column of data from the spreadsheet. I tried using the Chart Wizard<Pie<Series to create a new data series. Can this be done, or do I need to copy each pie chart as an image file (jpeg, bitmap, etc.) onto a new sheet?
(2) I would like the size of the pie chart to be scaled according to sample size. For example, one pie chart has a sample size of N=8. Another pie chart has a sample size of N=20. I would like to have the pie chart with the larger sample size to be larger. Can this be done?

Thanks-

[oldchippy]

May be this link will help you?

http://www.andypope.info/charts/piesizer.htm