Box plot template for Excel 2010

November 24, 2010 Jesper Excel Go to comment

I have updated the popular Box-plot template to work nicely with Excel 2010 and cleaned up the default chart a bit (see image below). It now should look more professional and less “chart-junky”. The attached template will allow you to paste your data into the work sheet. Default is 6 data series with 10 samples in each series. The template can also handle negative values.

Dowload template

box-plot-2010

Popularity: 4% [?]

16 Responses to Box plot template for Excel 2010

  1. G | #1
    On October 10, 2012 12:38 am

    I can’t thank you enough. I’m not a big Excel fan but this will patch up what I need to present until I get through some MATLAB code or R. Thanks a ton.

  2. Andrea | #2
    On October 25, 2011 11:42 am

    Is it possible to enter more than 11 values in the columns somehow? I need to enter 20 values, but don’t want to mess anything up.

  3. Dee | #3
    On October 20, 2011 5:06 am

    Thanks for making this available! There is still a problem however, the y-axis in the box plot is incorrect. I’m trying to figure it out… will post back if i do.

    • Dee
      On October 20, 2011 6:10 am

      @Dee: Ok, did it. It requires some manual setting of axis limits, but otherwise it works well. Do contact me if you want this updated version (as admin you have acces to my email, right?)

  4. Jesper | #4
    On August 21, 2011 6:31 am

    Removed the CPA Lead gateway. Download is now freely available.

  5. Greg Jones | #5
    On August 12, 2011 11:07 am

    It appears you have put together something that solves a deficiency in Excel. However, your requirement to ‘take a survey’ is actually not a survey, but a way in which these companies and trying to get me to buy something and gain my email address. I don’t want a Mercedes or a Mini Cooper or a iPad, I just want to figure out how to make a box plot in Excel!

  6. Wendy | #6
    On July 8, 2011 7:09 pm

    I cannot download the template. Help please?

  7. Scott | #7
    On June 16, 2011 10:15 pm

    Look, I appreciate you asking for support for your site but after going through an extremely long survey form for car insurance i don’t need i still wasn’t able to download the file. is there another way to get this file? if not, i’ll move on to another site or build from scratch.

  8. ema | #8
    On May 12, 2011 2:33 pm

    I have the same problems like the people above… The download-button dosen’t work with firefox, but with IE. However can’t download the likely helpful template because there ist no availability to my country. Is there any way to correct this failure? Greetings from Germany

  9. Rayna | #9
    On April 29, 2011 12:02 am

    what a load of shit you have to fill in a survey before you can get it?
    THUMBS DOWN…

  10. Rayna | #10
    On April 29, 2011 12:00 am

    Need this ASAP and the download button wont work – nothing happens :(

  11. Jesper | #11
    On March 23, 2011 3:49 pm

    There was a slight problem with the template files, but that should be fixed now.

  12. HuangJS | #12
    On March 9, 2011 5:24 pm

    “Please support my work and complete a survey to download this file.
    Sorry, There are no surveys available to your
    country at this time. Please try back later.”

    I cannot download nor do the surveys.

  13. James | #13
    On February 22, 2011 3:57 pm

    The link doesn’t work in Firefox or IE. The “Dowload File” can’t be clicked.

  14. Erin | #14
    On January 7, 2011 8:53 pm

    …you’re the best. I could not have done my box & whiskers project without you. I actually used it to plot out chunks of time when my multimedia lab is busy/free. Let me know if you’d like to see!

    • Andie
      On August 7, 2011 2:02 pm

      Big help, big help. And superlative news of cusore.