Google spreadsheet: box plots?

Question

I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Inesrt>Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have to make my own gadget using google charts API?

Answer 1

The closeted thing to a Boxplot Chart is a Candlestick Chart.

You could calculate all the data needed to plot a box chart: The Five Number Summary and plot each serie individually. Apparently, the width of the box isn't important.
I've prepared an example file: Box Plot example (sample data).

In Google Apps Script, the box charts are un-supported.

References:

• Boxplot Chart
• Candlestick Chart
• Supported chart types in Google Apps Script