How to☝️ Make a Venn Diagram in Google Sheets

To make a Venn diagram in Google Sheets, navigate to the Insert menu and select Drawing. In the Drawing window, add Oval shapes that intersect with each other (two or more as you need). Change the Color and Transparency of the ovals to make them look like a Venn diagram. Finally, add Text boxes to insert labels for each section of the Venn diagram.

To see how it’s done step-by-step, check out the article below to review the entire process.

What Are Venn Diagrams?

A Venn diagram is an integral part of set theory, mathematics, statistics, and computer sciences, allowing users to understand the relationship between two or more groups. 

Venn diagrams visually reveal which set shares common properties with another set as well as the non-common properties between them. Below are a few examples:

1. For products such as mobile phones, Venn diagrams can compare features that are shared as well as noting which features are different.

2. In biology, Venn diagrams can compare various diseases to see what common and uncommon symptoms they share.

3. Venn diagrams can also be used in literature to compare similarities and differences between two pieces of literature. 

How to Make a 2-set Venn Diagram

The most common Venn diagram is the 2-set Venn diagram. It allows users to compare and contrast two sets. The steps to create one for yourself have been divided into two parts:

  1. Drawing the Venn Diagram
  2. Formatting the Venn Diagram

Drawing the Venn Diagram

1. In your Google Sheets document, go to the Insert menu.

2. Click on the Drawing option, which allows you to insert a new drawing into the document.

Insert a Drawing

3. In the Drawing window, click on the Shape icon.

4. In the drop-down menu, select Shapes.

5. From the list of shapes provided, choose Oval.

Insert an Oval Shape

6. Draw an Oval, making sure it’s large enough to include text to label it.

Draw the first oval of an adequate size

7. Open the Actions drop-down menu from the Drawing window and click on the Duplicate option (keyboard shortcut Ctrl + D). This will make a copy of the oval shape.

Make a copy of the already created oval shape

8. Arrange the ovals to overlap each other. This is the basic shape of a Venn diagram.    Two Overlapping Oval Shapes

Formatting the Venn Diagram

With the ovals filled with color, we cannot see the overlapping area. We need to format it so we can see that area and add the necessary text to label it. Let’s take a look at how to do that:

1. Select one of the ovals. Click the Fill color option at the top and choose light orange 3 from the Solid section (or whatever color works best for your diagram).

Set the color as light orange 3 for the first oval

2. Select Fill color again and choose the CUSTOM option in the Solid section. This will open a new color customization window.

Click to acess Custom Color Settings

3. From here, you can see that the TRANSPARENCY is set very low (not transparent) by default. Increase the transparency so you can see through to the other oval. When done, click OK.

Set the Transparency to an adequate custom value

4. Select the other oval and repeat the steps above to change its color to light green 3. Don’t forget to increase the TRANSPARENCY in the CUSTOM menu.

Common area is clearly visible between two ovals

Because of the increased transparency, you can now see the common area where the two ovals intersect.

5. With the ovals now ready, we can insert Text boxes to label each section. Click on the Text box option next to the Shape menu in the drawing canvas.

Click on the Text box to insert adequate labels to the ovals

6. Draw text boxes inside the two oval shapes and insert the label text to complete this 2-set Venn diagram. The output should look similar to the one shown below:

Insert the Text inside ovals to create a Venn diagram

7. Finally, click the Save and Close button in the upper right-hand corner to implement all these changes and add the drawing to the Google Sheets document:

Google Sheets Venn Diagram

8. To make it more visually attractive, go to the View menu, select Show, and deselect Gridlines to remove the lines from the sheet so the background is blank. 

Remove the Girdlines from your view

Finally! Our 2-step Venn diagram is ready. At any time, you can adjust it to fit your needs, applying different text based on the situation or customizing the colors.

Venn Diagram Final

How to Make a 3-set, 4-set, or 5-set Venn Diagram

To create a 3-set Venn diagram, we have once again divided the entire process into two sections.

Drawing the 3-Set Venn Diagram

1. Go to the Insert menu in your Google Sheets document.

2. To insert a new drawing, click on the Drawing option in the menu.

Insert a Drawing

3. In the Drawing window that appears, click the Shape icon.

4. From the list, select Shapes.

5. You will see many shapes to choose from. Pick the Oval.

Insert an Oval Shape

6. Using your mouse, draw an Oval on the drawing board. Make sure it’s large enough to include label text.

Draw the first oval of an adequate size

7. Open the Actions drop-down menu from the Drawing window and click on the Duplicate option (keyboard shortcut Ctrl + D). This will make a copy of the oval shape. Do this twice so you end up with three ovals.

Make a copy of the already created oval shape

8. Adjust the ovals so they overlap each other. This is a crucial step. Overlapping ovals form the basic shape of a Venn diagram.

Three Overlapping Oval Shapes

Now comes the rest of the process: formatting the ovals so you can properly see the 3-set Venn diagram.

Formatting the 3-Set Venn Diagram

1. Select one of the ovals and click on the Fill color option at the top. Choose the light orange 3 color shade in the Solid section (or whatever color you prefer).

Set the color as light orange 3 for the first oval (2)

2. Return to the Fill color menu and choose the CUSTOM option in the Solid section. This will open a new color customization window.

Click to access the custom color setting

3. The TRANSPARENCY is set very low by default (not transparent). Increase it until you can see through it to the other ovals. Once done, click OK.

Set the Transparency to an adequate value of your choice

4. Repeat the steps for the other ovals, changing their colors to light green 3 and light red berry 3, respectively (or whatever colors you decide). Make sure you increase the TRANSPARENCY from the CUSTOM color menu.

Common intersecting area is clearly visible between three ovals

Because of the increased transparency, you can now see the common areas where the three ovals intersect.

Note: When increasing the TRANSPARENCY, be sure to set it to the same value for all the ovals so they appear uniform.

5. Now, since the three ovals have been customized, let’s insert Text boxes to label each section and intersection. Click on the Text box option next to the Shape menu in the drawing canvas.

Click on the Text box to insert adequate labels to the ovals

6. Draw the text boxes inside the three oval shapes and input the labels for each part of the 3-set Venn diagram. Your result should look similar to the example below:

Insert adequate text inside all three venn diagrams7. Finally, click the Save and Close button in the upper right-hand corner to save these changes and add the drawing to the Google Sheets document. It should look like this: 

3-set Venn Diagram

8. To make your diagram more visually attractive, go to the View menu, select Show, and deselect Gridlines to remove them from the sheet. 

Remove the Girdlines from your view

And just like that, our 3-step Venn diagram is ready to go. Feel free to adjust the colors or the text to fit your needs.

3-Step Venn Diagram Ouptut

Using the same process, you can also create a 4-set and a 5-set Venn diagram

Check out the 4-set Venn diagram example below to see how it works.

A 4-Set Venn Diagram

Though you may not need it all that often, here’s what a 5-set Venn diagram looks like:

A 5-Set Venn Diagram

Pro Tip: You can change the positions of the oval shapes in accordance with the common properties they share. In this case, there isn’t any situation where more than three events share common properties at a time. But you may come across a situation where there are more than three that share properties. This is where the 4-set or 5-set Venn diagrams can be useful.

Moreover, if you want to save time, you can access and use our free templates here (link).

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X