Counting the frequency of words and having it charted

Question

Level 1

4 points

Counting the frequency of words and having it charted

Hi,

I am new to Numbers and I can't for the life of me find a way to count the frequency of certain words in a row or column and having this information charted.

For example I would like Numbers to make a chart out of the following information (in the "Key" row):

Whereby it would look something like this:

It seems like a simple task so I don't know if it is just not possible to do this in Numbers or I am just plain stupid.

Thanks for Your help!

Mac Pro, OS X Yosemite (10.10.3)

Posted on May 26, 2015 10:25 AM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,329 points

May 26, 2015 10:56 AM in response to mirzojev

Hi mirzojev,

Formula in Table 1-1 B2 (and Fill Down)

=COUNTIF(Table 1::$2,A2)

Select columns A and B in Table 1-1 and insert a column chart

Regards,

Ian.

Reply