Unfortunately the majority of my data has the same issues. I was trying to show 5 or 6 box plots side by side. The max point is important to show but I wanted the audience to also get a feel for the distribution of the data points. That is why I was drawn to the broken axis for the whisker
In fact, the reason I used an error bar is that in Excel 7558, the line between the two boxes was twice as thick, because Excel didn 8767 t overlap the edges of the boxes instead you saw the two box outlines side by side. I hated that appearance. Since Excel 7557 the line between stacked boxes looks like a single line, and believe me, it looks cleaner.
Let's start by making a box-and-whisker plot (also known as a "box plot") of the geometry test scores we saw earlier:
Select this new series, then on the Chart Tools Design tab, click on Change Chart Type. If you are making a vertical box plot, choose a Line Chart style. If you are making a horizontal box plot, choose an XY Scatter style.
From time to time, we will publish comments from users who have shared positive testimonials about our Site. When we publish such content, we will identify those users only by their first and last name or a screenname, and their city, state and school.
Superimposing the plots is possible, but is likely to be difficult and problematic to do, and is also likely to result in something difficult to read.
It is not advisable to use quantities other than quartiles for box plots. You risk distorting the interpretation of those who are familiar with the standard box plot construction, causing them to overestimate the variability in the plotted data (mean ± 6 sd includes 68% of a population, while the interquartile range includes 55% of the population). You also risk distorting the future use of box plots by those who are not yet familiar with them.
Thank you so much for this! I 8767 d been tearing my hair out for weeks and continually have to use workarounds to present statistical data. Am so happy I could dance!
Finally, let 8767 s determine which values we need to plot. Our chart has a box for the second quartile, which shows the difference between median and first quartile calculated above. It has a box for third quartile, which show the difference between the third quartile calculation and the median. The bottom of the lower box rests on the first calculated quartile. The down whisker is as long as the first quartile minus the minimum, and the up whisker is as long as the maximum minus the third quartile.