"Linda" schrieb im Newsbeitrag
...
Is there a way do do stem and leaf diagrams using excel
and if so how do I do this.

Hello Linda,

I'm not familiar at all with this kind of Diagram, but if I had this
homework to do, I would try at first, for a Data in A1, determine
- the leave : using the function =RIGHT(A1,1)
- the stem : through the function =LEFT(A1,LEN(A1)-1)

in a second step I would sort together these two columns with priority for
the Stems in ascending order

At the last, with a macro, I would investigate the stems-Column, moving for
identical values of the stem, the corresponding leaf in the next column to
the right in the row where this value of the stem appears the first time
and delete all the rows where stems remain without leaves.

best regards

Jean