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.

Back to Back Stem Leaf Plot in Excel made using the QI Macros

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 toolbar. 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

    two sided stem and leaf plot
  2. Input or cut and paste your data into the yellow input areas

    back to back stem and leaf plot
  3. Double click on the button and QI Macros will perform the analysis and create the two-sided plot.

    two sided stem and leaf

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.

double sided stem and leaf plot

Learn More ...


Why Choose QI Macros?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free