Horizontal boxplots - Issues with mean values

hornofgondor

New Member
Joined
May 9, 2013
Messages
4
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 (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)




Mean221716131719201617161618171817
Offset0.51.52.53.54.55.56.57.58.59.510.511.512.513.514.5

<tbody>
</tbody>


http://postimg.org/image/5ormgktw1/a8a51276/
 
Last edited:

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,095,537
Messages
5,445,068
Members
405,313
Latest member
ashakantasharma

This Week's Hot Topics

Top