VBA code to create horizontal box plot?

Kelvin Stott

Active Member
Joined
Oct 26, 2010
Messages
325
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
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Kelvin Stott

Active Member
Joined
Oct 26, 2010
Messages
325
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).
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,095,541
Messages
5,445,090
Members
405,316
Latest member
joaoamaro

This Week's Hot Topics

Top