Results 1 to 3 of 3

VBA code to create horizontal box plot?

This is a discussion on VBA code to create horizontal box plot? within the Excel Questions forums, part of the Question Forums category; Hi, Does anyone have some VBA code to create a horizontal box plot (box and whisker plot, including points for ...

  1. #1
    Board Regular
    Join Date
    Oct 2010
    Posts
    310

    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
    VoG
    VoG is offline
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651

    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

    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 01:15 PM.

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