Box and Whisker Plots on Google Sheets

This tutorial shows how to create a box and whisker plot using Google sheets. On Google sheets, this graphical summary is called a candlestick chart. it's not a true box and whisker plot since it does not include the median inside the middle box or middle 50% of the data.

[@AJ-et3vf]

Great video. Thank you

[@user-bf2yq4hm4h]

Hello, I tried this and it worked great! However, do you know if there is a way to label the minimum and maximum on the chart itself?

[@IntelligenceEra]

I'm sorry if I missed it, but why is it that the maximum value doesn't show when the median value is added in?

[@creadoz_]

I only wanted to know how to add median to candle stick chart. Is it even possible?

[@user-jg3wl9vp2d]

Great! It helped me a lot. I have one question, can we not compare three data sets? Mine doesn't work.

[@AlRichards314]

Hi & thanks for the comment. I don't see why you couldn't compare 3 or more sets of data. I'll try later to see if that works.

[@AlRichards314]

Hey, I tried 3 data sets and it worked fine. Look here: docs.google.com/spreadsheets/d/1UctYDKduiaCCOaj1IT6Sq5fzSGxV0sbNhxbxavokoTE/edit#gid=0

[@user-jg3wl9vp2d]

@@AlRichards314 Thank you so much! It works!