How can we create a macros for multiple pie charts at a time

[varunk (Varun Kumar)]

Hi @ All

In one excel we have multiple sheets,for one macro we can create a pie chart for each sheet using one macro.
Can anyone suggest me how we can do this