A box and whisker plot can help you with a proper way to visualize and summarize the distribution of your critical data. Google Sheets directly don’t provide an option to do that but it’s possible using the below information mentioned in this article.
Table Of Contents
How to make a box and whisker plot in Google Sheets
Follow the below steps to make box and whisker plot in Google Sheets.
- Open your Google Sheets document.
- Select the range of cells and columns with data.
- Click on the Insert menu –> then select the Chart option.
4. On the Chart editor window, Select the Chart type as Candlestick chart from the Other category as shown below.
5. Now, you have created the box and whisker plot successfully. See the below screenshot.
FAQs
Q: Can you make a box and whisker plot in Google Sheets?
Answer: Yes, you can. Though there is no direct option but possible by creating a chart type as Candlestick chart by following the above information.
Q: How to do a box and whisker plot in Google Sheets?
Answer: Select the data –> Click Insert –> Chart –> Choose chart type as Candlestick chart from the Other category.
You may also like following the below articles:
Final Thoughts
In this article, we discussed how to make a box and whisker plot in Google Sheets. Thanks for reading this article !!!