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

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

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.

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

Following

Share this item with your network: