Pie Chart size relative to area/volume

[#1]

Hi Folks

Anyone now if it’s possible to automatically resize a pie chart to be proportional to a number of other charts based on its volume? i.e.

I can use vbscript to resize the frame automatically:

But I’d prefer to resize the chart inside the frame instead i.e.

thanks

D.