Dot Plot Excel 2011. With dot plots its easier to compare relative positions so you dont have to start the scale at zero. The individual values are shown along the x-axis and the frequencies of those values are represented by the number of dots.
In this post I want to show you an alternate way to make a lollipop graph. Change the x-axis to only span from 1 to 7. Height data provides the vertical coordinates for Y axis.
It is not available as a default Excel chart but with a few tweaks you can easily turn one of the available charts into a dot plot.
In this post we shall look at easy steps that you can take to make dot plots. Simple Box and Whisker Plot. They are useful for highlighting clusters and gaps as well as outliers. Their other advantage is the conservation of numerical information.
