Creating a Stem-and-Leaf Plot with Digits as the Leaves Using Sorting and
Formulas
It is possible, with a bit of sorting, to create a stem-and-leaf plot that does not require a
361-character formula.
Assuming that your data is in A2:A26, you follow these steps to create a stem-and-leaf plot:
1. Sort the data in descending order.
2. Enter the headings Stem, Leaf, and Leaves in cells B1, C1, and D1, respectively.
3. Enter a formula of =INT(A2/10) in cell B2. Copy the formula from cell B2 down to all
rows.
4. Enter the formula =A2-B2*10 in cell C2. Copy this formula down to all rows. (You
could also use
=MOD(A2,10) or =RIGHT(A2,1).)
5. Enter the formula ...