Question

Excel 2003 - How to sum up a chart with percentage

Excel 2003

I have created a worksheet to track when letters are sent out. I have a column (1) for the name of the recipient and a column (2) for the date the letter was sent. How do I track what percentage of the letters have been sent?
I would like a graph/chart, either bar or pie, that will tell me how many of the letters have been sent.
For example I have 10 letters to send. Once I have sent a letter, I enter the date sent in column 2.
How do I create a chart that will tell me what percentage of letters have or have not been sent? In the example above all 10 letters equal 100%. If I have sent 2 letters then the chart should be at 20%.

Help please!

I do not wish to be rude, but this reads like a school homework question. So, I will simply give the basic facts you need, To count a column of names in a named range called "TheNames" you could use the formula COUNTIF(TheNames,"*"). To count a named range called "LettersSent" that stores dates or blanks use COUNT(LettersSent). It should be easy now to construct a couple of cells that store the values of number of letters sent and number of letters yet to be sent and use these cells as the data for a pie chart.