I have created an EXCEL 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'm assuming that your contacts are in column A and the dates are in column B and that there is no other information in those columns. Somewhere in another two columns put the following two formulae: =COUNTA(A:A) and =COUNTA(B:B) I put them in cells C2 and D2 and I then put the following formula into cell E2, which I formatted as a percentage: =D1/C1 I put labels Addressee, Date Sent and % Sent in cells C,D and E1. This allowed me to base a chart, which could show the labels, on the range C1:E2.

Yes, of course I can do that. But how do I create a chart/graph that will automatically do that for me? I know how to do it if I had numbers in the date field... How do you tell the chart/graph that each date column is part of the 100%?

Only thing I can think of is to total column (1) and column (2), divide the total of column 2 by the total of column 1 and you will get the percentage of letters that have been sent.