frequency plot of values in a row

**phalaris** · 02-10-2010, 10:12 AM

Hi,

I have a really simple problem, but I'm not sure how to phrase it so I can't seem to find the answer on Google.

One of my rows looks like this:
1 2 1 1 2 3 2 1 1 3 5 4

I simply want a plot of these values on the x-axis against their frequency of occurence in the row

so it should look like:

|
|
| |
| | |
| | | | |
1 2 3 4 5

What is the easiest way to achieve this?

Thanks!

**shg** · 02-10-2010, 10:23 AM

Not clear what all those pipes represent.

If your values are in A1:L1, then in A1:E1, =TRANSPOSE(FREQUENCY(A1:L1,COLUMN(A2:E2))), confirmed with Ctrl+Shift+Enter returns

Please Login or Register  to view this content.

**phalaris** · 02-10-2010, 10:42 AM

With the pipes I was trying to show what the bar chart should look like.
I would like all my unique values in the row to appear on the x-axis (i.e. the row contains the numbers 1,2,3,4,5 so I want 1,2,3,4,5 on my x-axis) and this should be plotted against the frequency of occurence on the y-axis (i.e. 1 appears 5 times so I used 5 "pipes" to indicate that the bar should be 5 units high for the value 1 in the bar chart, etc.)

EDIT: ok I understand the code now, I think I have all I need. Thanks for the help

frequency plot of values in a row

LinkBack

Thread Tools

Rate This Thread

Display

frequency plot of values in a row

Re: frequency plot of values in a row

Re: frequency plot of values in a row

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions