How to create pie chart in Excel2003 using c#

Hi,

i want to create pie chart in Excel 2003 usign c#.
Actually i have tow columns(A,B) in my excel. one is question and another is response("yes/No").

so i have a count of number of yes and number of no. so i need to drwa a pie chart which show show no of ues and no of no.no of yes should be in blue color and no of no should be red color. so please show me some sample code to draw pie chart in Excel using c#.