In this article:

How to Make a Venn Diagram in Google Sheets (2024 Guide)

March 29, 2024

How to Make a Venn Diagram in Google Sheets

You can create a Venn diagram in Google Sheets using the Drawing tool. Here's how to do it:

1. Open the Drawing Tool

Click on Insert in the top menu. Choose Drawing from the dropdown menu.

venn diagram google sheets

2. Create Circles for the Venn Diagram

Select the Shape icon (it looks like a circle overlapped by a square) from the toolbar. Choose Shapes, then select the circle shape.

make a venn diagram in google sheets

Click and drag on the canvas to draw a circle. To make the circles transparent, select the Fill tool in the toolbar and click on "Transparent."

google sheets venn diagram

Repeat the process to create a second circle that overlaps the first one or you can simply copy and paste the first circle, forming the basic Venn diagram structure. Adjust the size and overlap according to your needs.

venn diagram in google sheets

3. Customize Your Circles 

To add text to your circles, click on the Text box button (T icon) in the toolbar, then click and drag to draw a text box where you want your text. Type in your labels or descriptions for each section of the Venn diagram.

how to make a venn diagram in google sheets
can you make a venn diagram in google sheets

4. Save and Insert into Sheet

Once you are satisfied with your Venn diagram, click the Save and Close button at the top right corner of the Drawing tool. 

google sheets how to make a venn diagram

The Venn diagram will then be inserted into your Google Sheet. You can click and drag to move it or use the corners to resize it.

create a venn diagram in google sheets

We hope that this article has helped you and given you a better understanding of how to make a Venn diagram in Google Sheets. If you enjoyed this article, you might also like our articles on how to calculate a moving average in Google Sheets and how to use vertical align in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->