I want to create a simple box plot from 1D data, which doesn't seem to be supported by the default Insert → Charts. There is a histogram gadget but I haven't seen any box plot gadgets.

Do I have to make my own gadget using Google Charts API?


The closest 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).


enter image description here enter image description here

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


I've created an example file for you: Box Plot


  • sorry for the ignorant question, still trying to understand the difference between both, even after reading wikipedia: if not plotting outliers, why not simply using the candlestick? – cregox Sep 8 '18 at 11:29

You can use the addon g(Math) it is under statistical display and will create a box and whisker chart as below. enter image description here

  • 1
    box and whisker is typically helpful when charting multiple simultaneously on the same scale. I don't see a way to do that with this... – George Mauer Oct 19 '16 at 19:04
  • I can't find this add-on. Could somebody please provide a link? – lucas Feb 23 at 9:41

protected by Community Jun 18 at 9:18

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

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