I have to create several 'pie on pie' charts. I have created a couple before
and they seemed to work ok, apart from one problem. The 'slice' in the main
pie from which the second pie is created (the 'other' slice) seems to
determine its own size, however, I need to specify the exact size of this
slice and can't seem to find how to do it.

Below is an example of the kind of data I have to work with. We have sent
out 700 application forms, received 200 replies and we have then got the
average scores from each application form. The first pie chart needs to
contain a slice for 700 and another for 200. 'Branching' off the 200 slice
should be the second pie chart consists of the scores.

Again, I have created these before but the 200 slice didn't actually
represent 200, as Excel creates it as an 'other' slice and defines the size
of it itself?

Can anybody help on this??

Sent Out Received back V Good Good Average Poor
700 200 6.8 9.69 2.4 0.55