Pie Chart to pull data from single column

Greetings

I'm doing a termination report at work and I need to create a pie chart based on data in a selected column. Ive never used excel charts before but I cant get the pie chart to display the information that I want.
I created a sample workbook. Its very a simple column of data. I would like a pie chart based on the percentages of "yes" to "no". I havent been able to get it to work.

Thank you.

Pie Chart Help.xlsx

I have posted this in another forum as well but i have yet to recieve a reply. Heres the link:
http://www.ozgrid.com/forum/showthread.php?t=181175

Nevermind I figured that out. just so that have more options available are you able to show me the pivot table/chart route as well?

Im trying to create the pivot chart but it keeps saying my reference is not valid even though I selected my range of data and where I want to place the chart.....

the source data box includes the range which includes that entire column of data under hire and I have the destination box set to place th pivot table starting in E1

Source Data Box: Sheet1!$A$2:$A$21 Destination Box: Sheet1!$E$1

I did that but it still keeps saying that the data source reference is not valid. Really weird.

Alright I got it now. Lets say I have four columns of data that I want four different pie charts for. If I created pivot charts for each graph how can I make it so that when I filter one field it changes all of the graphs acording to that filter? In other words how do I link all the pivot tables together so that they all filter together based on the order in which you filter certain fields?

Alright I wasn't able to find anything suffice on contexture.com. Are you able to provide a code that would assist me? I have little VBA experience although I am learning. Thank you in advance for your patience.