Want to Create a Stem and Leaf Plot in Excel?

QI Macros has a Ready-Made Stem and Leaf Plot Template!

To create a Stem-and-Leaf Plot:

  1. Use Find Tools to locate the "leaf" template
  2. Enter your data into the data column.
  3. Click the button to create the plot.

What is a Stem and Leaf Plot?

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

  • Stems represent the first digits of the data points
  • Count represents the number of data points with that first digit
  • Leaves represent the second digits in the data set (numbers 0-9)
  • Median is the mid point in the data set and is shown next to the leaf

Stem and Leaf Plot Example Created Using QI Macros add-in for Excel

stem and leaf plot in Excel


It's Super Easy to Use QI Macros Stem and Leaf Plot Maker

  1. Open the Stem and Leaf Plot Template by clicking on QI Macros menu > Chart Templates > Stem and Leaf Plot
  2. The template will open and contains some pre-populated sample data.

    stem leaf plot excel template
  3. Input or cut and paste your data into the yellow input area.
  4. Double click on the update plot button and QI Macros will sort the data and populate the stems and leaves.

Why Would I Use a Stem and Leaf Plot?

A stem and leaf plot can help show the distribution of your data. It is similar to a histogram that is turned on its side. Let's use some average temperature data to better illustrate the relationship.

Stem and Leaf Plot

stem and leaf example

Rotate Results

rotate results

Histogram of the Same Data ( Bin width = 10)

histogram with bin width 10

Many people use stem and leaf plots because histograms seem too hard to create. But both are easy to make using QI Macros.

Learn More ...

Haven't you waited long enough?
Start creating your Stem and Leaf Plot in just minutes.

Download a free 30-day trial. Get the Stem and Leaf Plot now!

The Stem and Leaf Plot is one of many charts and tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find and open any chart template you need.

menu location for improvement charts

Other Charts in QI Macros Add-in for Excel