BoxPlot in Excel

Two years back around this time, while working with matlab, I came across the plot called boxplot.

Liked the idea of. Ever since I wanted to replicate that in one my fav language of choice, fortran.

Well that became part of my work.

While reasearhing boxplot on google, I came across this page. Loved the idea of creating boxplots in excel.

So coded this excel VBA macro that takes in some numbers and creates a boxplot for it.

The video below shows how this works.

Download the excel file and don’t forget to look under the hood.
or for those who don’t want to download, here’s the complete code.

6 thoughts on “BoxPlot in Excel

  1. Pingback: How to create Fortran DLL in Visual Studio with Intel Fortran compiler «

  2. Pingback: Evolution of BoxPlots «

  3. Pingback: An Excel App for Your Brain! |

  4. Pingback: Pareto Chart in Excel |

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s