Dot Plot Excel 2011. While Excel 2013 doesnt have a chart template for box plot you can create box plots by doing the following steps. In a new column column C in this case enter the column header as you need select the second cell enter the below formula into it and press the Enter key.
Height data provides the vertical coordinates for Y axis. Scatter plots are often used to find out if theres a relationship between variable X and Y. This will leave us with a dot plot that looks like this.
Calculate quartile values from the source data set.
In a new column column C in this case enter the column header as you need select the second cell enter the below formula into it and press the Enter key. Just list the category labels in column A. Change the x-axis to only span from 1 to 7. While Excel 2013 doesnt have a chart template for box plot you can create box plots by doing the following steps.
