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
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.
- First, select your data.
- Then, click on the QI Macros menu, select "Box, Dot & Scatter Plot" and then "Values Plot":
- 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.
Box and Whisker Plot
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.