## Excel 2003 – How to sum up a chart with percentage

5 pts.
Tags:
Microsoft 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!

Thanks. We'll let you know when a new response is added.

Thank you for visiting ITKE.

We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.

For starters, though, this may help: 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