A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Stem and Leaf Diagrams using Excel



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2003, 07:32 PM
Linda
external usenet poster
 
Posts: n/a
Default Stem and Leaf Diagrams using Excel

Is there a way do do stem and leaf diagrams using excel
and if so how do I do this.
  #2  
Old October 12th, 2003, 12:29 AM
Jean Ruch
external usenet poster
 
Posts: n/a
Default Stem and Leaf Diagrams using Excel


"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


  #3  
Old October 12th, 2003, 02:42 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default Stem and Leaf Diagrams using Excel

[This followup was posted to microsoft.public.excel.charting with an
email copy to Linda.
Please use the newsgroup for further discussion.]

XL doesn't have any built-in capability, nor can I think of any easy
way to create this kind of chart. If you search google for "stem and
leaf" (including the double quotes), you'll find any number of
references on how a stem-and-leaf diagram works. They can be adapted,
though not easily, in XL. Thinking out aloud, this is possibly one of
those visual displays that is easier to create through the judicious
manipulation of worksheet contents and formatting rather than through a
'real' chart.

--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Is there a way do do stem and leaf diagrams using excel
and if so how do I do this.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.