Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create a simple boxplot 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 boxplot gadgets.

Do I have to make my own gadget using google charts API?

share|improve this question
up vote 5 down vote accepted

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


share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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