up vote 0 down vote favorite
share [g+] share [fb]

Excel does not come with boxplot charts.

What is the best technique to simulate boxplot charts in Excel?

I'm interested to

  • draw horizontal and vertical charts
  • display the mean in addition to the quartiles and median.
link|improve this question
Related: superuser.com/questions/132038/… – ewernli Dec 26 '11 at 11:03
feedback

1 Answer

up vote 2 down vote

The best I've found is this one: Peltier Tech Box and Whisker Chart Utility for Excel

enter image description here

  • Supports vertical and horizontal charts
  • Displays the mean in addition to the quartiles and median.
  • Comes with an Excel file to tweak for quick results.
link|improve this answer
You might need to install the service pack for Excel 2008 Mac to have "custom error bars", as requested per the technique. Service pack I had to install: microsoft.com/download/en/confirmation.aspx?id=7799 – ewernli Dec 26 '11 at 13:16
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.