This is a discussion on Horizontal boxplots - Issues with mean values within the Excel Questions forums, part of the Question Forums category; Hello all, I am trying to create a horizontal boxplot for 15 different categories. I am pretty much done with ...
I am trying to create a horizontal boxplot for 15 different categories. I am pretty much done with creating the 5th, 25th, 50th, 75th, and the 95th percentiles. I tried to introduce the mean values onto the boxplot as mentioned in the peltiertech boxplot website (Excel Box and Whisker Diagrams (Box Plots) - Peltier Tech Blog). However, for some wierd reason my mean values are not exactly aligning with their respective boxplots. I do not understand the exact reason for this although I am suspecting that it could be due to the offset value specification. Below, I have provided the mean values along with the offset values. Also, I am providing a link to the the chart below. Can anyone kindly suggest me the best offset values (or another suggestion if this is not the cause for this misalgnment)
Mean 22 17 16 13 17 19 20 16 17 16 16 18 17 18 17 Offset 0.5 1.5 2.5 3.5 4.5 5.5 6.5 7.5 8.5 9.5 10.5 11.5 12.5 13.5 14.5
Last edited by hornofgondor; Oct 10th, 2013 at 11:46 PM. Reason: Add image