Want to Draw a Values Plot in Excel?

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

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

Values Plot Example Drawn Using QI Macros

values-plot-image

How to Create a Values Plot in Excel Using QI Macros

While its 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 plot macro to QI Macros add-in for Excel. Its 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 Plot":

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

Compare a Values 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 Plot

values 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