Mac Numbers Notes

From Federal Burro of Information
Revision as of 14:56, 30 March 2020 by David (talk | contribs) (Created page with " start at the top, no gaps, leave header blank. Make a col of data. not a header col in the next col over make you buckets in the next col over at the top: =INDEX(FREQU...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search


start at the top, no gaps, leave header blank.

Make a col of data. not a header col

in the next col over make you buckets

in the next col over at the top:

=INDEX(FREQUENCY(A$2:A$79,C$2:C$11),ROW()−1)

then drag the yellow handle in the middle bottom of the cell down to "fill down"

Something like this:

Select the bucket and values cells and make a chart , 2 d column.