I had an assignment at class and couldn't do it because I didn't get the stem
and leaf chart in Excel. Can anyone assist me in how to create a stem and
leaf plot?
Thanks.

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



"Dessi Bravo" wrote in message
...
I had an assignment at class and couldn't do it because I didn't get the
stem
and leaf chart in Excel. Can anyone assist me in how to create a stem and
leaf plot?
Thanks.

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

A few more examples,
http://www.mrexcel.com/pc16.shtml

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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



"Dessi Bravo" wrote in message
...
I had an assignment at class and couldn't do it because I didn't get the
stem
and leaf chart in Excel. Can anyone assist me in how to create a stem and
leaf plot?
Thanks.