How do I use Excel to make a stalk and leaf diagram?

How do I use Excel to make a stalk and leaf diagram?

I use is excel2007, in addition, use Excel to do the stem leaf diagram needs a plug-in software PHSTAT2, if necessary, please go to Baidu download Oh.

1, unzip the compressed package, locate the setup file in the PHStat2 folder and double-click the installation.

2. Open Excel

3, on the desktop double-click PHSTAT2

4, and then open the Excel you just opened (usually you double-click the interface will go directly to the Excel you just opened). You'll find that there's more in the menu bar: add-ins

5, click on the add-in, you can see PHSTAT2

6, choose you want to do the data of the stem and leaf map, if your data is grown this way (picture 1), please be sure to change it to this way (picture 2), that is, the data all vertical column arrangement, otherwise in the use of phstats will occur when the error

7. Select stem and leaf display

8. In the Variabale Cell range of the pop-up box, enter the vertical column where the data resides, or box select, not select the contain label for the cell. Other items do not need to change, click OK.

9. Effect Drawing

Note: Data vertical column arrangement, do not select the contain label.