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


| improve this answer | |
  • 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

| improve this answer | |
  • 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 '19 at 9:41

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