Mac Numbers Notes: Difference between revisions
From Federal Burro of Information
Jump to navigationJump to search
(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...") |
(No difference)
|
Latest revision as of 14:56, 30 March 2020
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.
