Want to Draw a Values Plot or Variation Plot in Excel?

QI Macros add-in Can Help You Draw a Values/Variation Plot in Seconds!

Why it Matters: Use a Values/Variation Plot to show the spread of individual data points.

Values/Variation Plot Example Drawn Using QI Macros

values-plot-excel-output

How to Create a Values/Variation Plot in Excel Using QI Macros

While it's possible to create a values plot in Excel, it is very time consuming and you have to know what all of the steps are. To save time, we added a values/variation plot macro to QI Macros add-in for Excel. It's super simple and takes just seconds!

QI Macros installs a new tab on Excel's menu.

  1. First, select your data.
  2. Then, click on the QI Macros menu, select "Box, Dot & Scatter Plot", and then "Values-Variation Plot":

    values plot data
  3. QI Macros will perform all of the calculations and draw a Values/Variation Plot for you!

Compare a Values/Variation Plot to a Box and Whisker Plot

Using the same data, you can also run a Box and Whisker Plot which will perform a more robust analysis of your data. QI Macros can create Box and Whisker Plots, too!

Values/Variation Plot

values-plot-excel-output-vs-box-and-whisker-plot

Box and Whisker Plot

box-and-whisker

NOTE: A Values Plot is typically used with Variable Data. When using Attribute Data, keep in mind that the Values Plot DOES plot the entirety of your data set. However, it does not automatically uncluster/offset groups of multiple points w/ the same numerical value in a column, like in an Individual Value Plot. QI Macros does not offer an Individual Value Plot.

Stop Struggling with Values Plot!
Start creating your Values Plot in just minutes.

Download a free 30-day trial. Get Values Plot now!


Learn More


Other Charts Created by QI Macros add-in for Excel