In this article:

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

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.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started