Excel 2003 – How to sum up a chart with percentage

5 pts.
Tags:
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!
ASKED: April 8, 2008  8:29 PM
UPDATED: April 12, 2008  4:52 AM

Answer Wiki

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following