Home » Knowledge Base » Improvement Charts » Back to Back Stem and Leaf Plot

Back-to-back Stem and Leaf Plot Template in Excel

Create a double or two-sided stem and leaf plot in seconds.

A stem and leaf plot shows the spread and distribution of a data set.

• Stem represents the first digits of the data points
• Leaves represent the second digits in the data sets (numbers 0-9)
• Median is the mid point in the data set and is shown next to the leaf

A back-to-back stem and leaf plot shows two data sets. The data sets share the same stem and have their own set of leaves.

Example of a double stem and leaf plot created by QI Macros add-in for Excel.

It's easy to create both single and double stem and leaf plots using QI Macros

QI Macros installs a new menu on Excel's tool-bar. To create a stem and leaf plot:

1. Click on the QI Macros menu, then Chart Templates, then Stem and Leaf Plot to open the template
   
   
2. The template will open and contains some pre-populated sample data.
3. Input or cut and paste your data into the yellow input areas
   
   
4. Double click on the Update Plot button and QI Macros will perform the analysis and create the two-sided plot.
   
   

When Should I Use a Back-to-Back Stem and Leaf Plot?

Use a back-to-back or double sided stem and leaf plot when you want to compare the spread and distribution of two data sets. You can also use side by side histograms for the same purpose or lay the plots on their sides for a different view.

Learn More ...

• Stem and Leaf Plot
• Histogram with Cp and Cpk

---

Why Choose QI Macros?