I have a column of words, some of which are repeated. I want to make a chart showing how many times the words are repeated. Is there an easy way to do this? My first thought is to use COUNT to find out how many times each word is repeated, make a 2 column chart, and then graph that, but I feel as if there should be a much simpler way to do this. There are 50+ different words in this which makes my method incredibly inefficient. Any help would be greatly appreciated.
use pivot table for that kind of work.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Post the data in a workbook and we can show you how easy this is with pivot chart
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks