Two points.

1) We cast a suspicious eye upon pie charts around here. Could you do like a column chart instead???

2) "No way you have tried is successful"... did you try the official instructions for creating a pie-of-pie chart? That's basically how I was going to tell you to do it, only more completely written out.

EDIT: BTW those instructions are for Excel 2003. I dunno what kind of support Excel 2010 has for pie charts.