How to I create a Chart in Excel 2007 from Non Numerical Data?

5 pts.
Tags:
Excel 2007
Microsoft Excel
Microsoft Excel spreadsheet
We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could help I would really appreciate it!

Answer Wiki

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

If you are trying to create a graph depicting the number of items beginning with “A”, “B”, etc, then you will need to compute those into a chart and create your graph from there.

So let us say you want to count the number of items that begin with the letter “G” in column C. You could use the equation =COUNTIF(C:C,”G*”). This will give you a numerical value for “G” in your chart. Repeat this effort for your other alphabetic values and you will have created a chart for yourself.

I hope I answered your question. Let us know how it goes. Good luck.

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