VBA code to create horizontal box plot?

[Kelvin Stott]

Hi,

Does anyone have some VBA code to create a horizontal box plot (box and whisker plot, including points for mean values) based on selected data?

Any help (code or link to code) would be much appreciated, thank you!

Kelvin

 

[VoG]

This isn't VBA but it may help you Excel Box and Whisker Diagrams (Box Plots) | Peltier Tech Blog | Excel Charts

 

[Kelvin Stott]

Thanks. I played around with the downloadable example worksheet in this link for a good while, to see if it works properly before reproducing it with VBA code, but unfortunately it doesn't work when the box starts below the axis at zero (i.e., when the first quartile is negative).