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 tool-bar. To create a stem and leaf plot:

  1. Click on QI Macros > Chart Templates > Stem and Leaf Plot to open the template:

    two sided stem and leaf plot
  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:

    stem and leaf back to back template input
  4. Double click on the Update Plot 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?



  • Only $329 USD - less with quantity discounts
  • No annual subscription 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

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free