Boxplots - Issue with mean values

Hello all,

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 (http://peltiertech.com/WordPress/exc...ams-box-plots/). 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 attaching the chart image. 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

bxp.png

Originally Posted by Andy Pope

you need to post example file so we can see the actual chart and it's properties.

I am attaching the excel file. Thanks.bxp.xlsx

Originally Posted by Andy Pope

the secondary vertical scale should be Min=0 Max=15

This works perfect. Thanks for your help Andy.