How to Make a Dotplot in MS Excel 2007



This 4 minute video shows you how to trick Excel into making a dotplot out of a scatterplot. Dotplots are commonly used graphical mechanisms for displaying the distribution of numerical data. Since the basic package of Excel does not have a routine for making dotplots, you should find this technique useful.

23 thoughts on “How to Make a Dotplot in MS Excel 2007

Leave a Reply

Your email address will not be published. Required fields are marked *