View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Gaj Vidmar Gaj Vidmar is offline
external usenet poster
 
Posts: 6
Default St4em and Leaf Display or Plot

It may be as low as no. 23 on Google's result list for "excel stem leaf",
but it may be an excellent solution:

http://www.mf.uni-lj.si/ibmi-english...ndLeafPlot.xls

If you dont' want to mention or use it just because it's (partly) mine,
here's another workbook with macro that produces S&L plots:

http://statistics.unl.edu/faculty/bi...m-and-leaf.xls

For putting things in a broader perspective, stem-and-leaf plots can be
classified under "charts Excel can't do" (though, of course, it can):

http://epublications.bond.edu.au/ejsie/vol1/iss3/6/

For a somewhat more scholarly and more comprehensive article on such and
other matters of statistical graphics in Excel, one might read (again, can't
help it, it's mine)

http://www.mf.uni-lj.si/ibmi/biostat.../MZ_Vidmar.pdf

Regards, Gaj
---
Dr. Gaj Vidmar
Institute for Rehabilitation, Republic of Slovenia

"Mike Middleton" wrote in message
...
Dessi Bravo -

Excel does not have a built-in feature for stem and leaf charts.

Perhaps your class is using a textbook that has an Excel add-in that
produces such charts.

If not, browse to www.google.com, and search for "excel stem leaf"
(without the quotes), and you'll find some instructions about creating a
stem and leaf chart using Excel.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel