How can I use VBA to create multiple pie charts from a series of data

Hi

I need help creating multiple pie charts from a series of data, Basically there are 2 weekly totals that I need to make into a weekly pie chart, is there anyway I can do this without creating a chart for each individual week manually and having them produced automatically with a vba.

It would be a great help if anyone could help me.

Thanks

John