Excel 2007 : Multiple Pie Charts

Hi,

I was wondering if there is a way to insert multiple pie charts in one go rather than individually.

I'm working with a large data set which details breeds of dogs for a study into epilepsy (there are cases and controls for each breed), and the sexes breakdown of each breed. I have attached a sample of the dataset so that you can get an idea of what I'm talking about.

I want to draw up pie charts for each breed (case and control) showing the *** distribution. At the moment I'm having to do it one at a time for each breed, which is taking a while. Any way to produce all the charts in one go?

Cheers.

P.S. I have my Excel 2007 set to save as 2003, as my supervisor doesn't have 2007 and I need to email all my reports to him.