VBA code to create horizontal box plot?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: VBA code to create horizontal box plot?

  1. #1
    Board Regular
    Join Date
    Oct 2010
    Posts
    310
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA code to create horizontal box plot?

     
    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

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: VBA code to create horizontal box plot?

    HTH, Peter
    Please test any code on a copy of your workbook.

  3. #3
    Board Regular
    Join Date
    Oct 2010
    Posts
    310
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code to create horizontal box plot?

      
    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 by Kelvin Stott; Mar 29th, 2013 at 02:15 PM.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com