I also want to know the answers , somebody help ?
[Signature removed by Moderator]
Try recording a macro before creating the pie chart.
Once the recording is done you can remove the pie chart and run the recorded macro to instantly create the chart.
Is that what you were looking for?
Otherwise specify in great detail.
Thank you so much for your help Trowa :) I think I got it !