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?


2 Answers 2


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, 2018 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... Oct 19, 2016 at 19:04
  • I can't find this add-on. Could somebody please provide a link?
    – lucas
    Feb 23, 2019 at 9:41

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