Excel Magic Trick #124: Box Plot or Box & Whisker

See how to create a Box Plot or Box & Whisker Statistics chart using a Stacked Bar Chart and a Open-High-Low-Close Stock Chart. See how to use the QUARTILE function. See how to link Chart Labels to cells.

Category:

Science & Technology

Tags:

• Excel
• Box
• Whisker
• Plot
• Stacked
• Bar
• Chart
• Stock
• QUARTILE
• function
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[JaqualinIsBallin]

Thank-you thank-you thank-you!!! Helped so much with my AP Statistics final project, you have NO idea how stressed out I was! Thanks :D

[ExcelIsFun]

@JaqualinIsBallin , you are welcome!

[tondominguez]

Thanks a lot, followed on Excel 2010 and it still worked :D

[ExcelIsFun]

@tondominguez , EXCELlent! I am glad that it worked!

[younglife88]

Very Useful! Thanks so much for the help! 

[ExcelIsFun]

@younglife88 , I am glad that it helped!

[whitneyxox4u]

thank you! you helped me sooo much!



[StreetKingEvolution]

Thank you so much!

[REDivivus5]

easy to follow and incredibly helpful even with excel 2010. (: thank you!

[Reecie5699]

You need a pop filter or something

[BenPajamas]

So much help!!!!

[GE0SH]

not working, I keep getting this message "...arrange the data on your sheet in this order: opening price, high price, low price, closing price..." but I have that data set up just as you do

[danielkueh]

Do you know how to create multiple box plots?