+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Stem-and-leaf in Excel. Boo-ya. (/showthread.php?tid=76246)
Stem-and-leaf in Excel. Boo-ya. - Greg - 04-12-2009
Stem-and-leaf diagrams serve the same purpose as histograms, but take up less space. Good for corporate presentations and stuff, assuming management cares to try different approaches.
The trick is to make a scatterplot.
Edward Tufte rocks, and all that.
Good stuff here, too: http://www.mrexcel.com/pc16.shtml
http://files.me.com/gdermer/eobjim
Re: Stem-and-leaf in Excel. Boo-ya. - morlock - 04-12-2009
Stem and leaf? I always pick them out. How do you feel about seeds?
Re: Stem-and-leaf in Excel. Boo-ya. - Greg - 04-12-2009
Boo-ya nothing...think it still needs work. :-)
Re: Stem-and-leaf in Excel. Boo-ya. - Greg - 04-13-2009
Let's try that again.
http://files.me.com/gdermer/n2soca
The "diagram" comes from nicely-formatted cells, not a chart.