Excel Venn Diagram

Last Updated :

-

Blog Author :

Jeevan A Y

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

How to Create a Venn Diagram in Excel? (2 Methods)

Below are the two methods to create a Venn diagram in Excel.

  1. Create a Venn Diagram using Excel Smart Art
  2. Create a Venn diagram using Excel Shapes
Table of contents

Now let us discuss each of the methods in detail along with an example

#1 Create a Venn Diagram Using Excel Smart Art

Follow the steps to create a Venn diagram in Excel.

  1. We must first go to the "Insert" tab and click on "SmartArt."


    Venn Diagram Example 1

  2. Now, we can see the SmartArt window below.


    Venn Diagram Example 1-1

  3. Select the "Relationship" category.


    Venn Diagram Example 1-2

  4. After that, we must scroll down and select the "Basic Venn" diagram.


    Venn Diagram Example 1-3

  5. Once the choice is made, we will now have the selection below the "Basic Venn" diagram.


    Venn Diagram Example 1-4

  6. Now, click on "Text" to enter the text as VLOOKUP, HLOOKUP, INDEX + MATCH.


    Venn Diagram Example 1-5
    This diagram shows that all three formulas belong to one category, LOOKUP functions.

  7. Now, we can play around with the formatting of the smart art under the "Design" tab. First, click on the "Design" tab >> "Change Colors."


    Venn Diagram Example 1-6

  8. We can change the color as per our liking.


    Venn Diagram Example 1-7

Like this, we have many Venn Diagram examples based on our requirements. We can choose different Venn diagrams.

different types of excel Venn Diagrams

#2 Create Venn Diagram Using Shapes in Excel

  • Step 1: We must go to the Insert tab, click on "Illustrations," and select "Shapes," then choose "Oval" shape.
Insert tab - click on Illustrations and select shapes
  • Step 2: First, we must draw an oval shape.
Venn Diagram Example 2-1
  • Step 3: Like this, we can draw two more oval shapes in the form of a Venn diagram. And, make the "Fill" as "No Fill."
Venn Diagram Example 2-2
  • Step 4:  Now, we must insert "Text" boxes for each circle.
VennDiagram Example 2-3
  • Step 5: We have inserted 5 text boxes. In the first box, we must write “VLOOKUP.” In the second box, we must write "INDEX + MATCH." Finally, in the third box, we must write "HLOOKUP."
VennDiagram Example 2-4
  • Step 6: We have another two boxes. You must be wondering what we need to write with these boxes. In the middle text box, write "LOOKUP" functions, and in the other box, we must write "One Dimensional."
VennDiagram Example 2-5
  • Step 7: From this diagram, we can interpret as there are three formulas: VLOOKUP, HLOOKUP, and INDEX + MATCH. All these are LOOKUP functions so related to each other.

The middle text box Lookup Function in excel belongs to all the circles.

VennDiagram Example 2-6

Then we have one more box which says "One Dimensional." However, it applies only to the boxes "VLOOKUP" and "HLOOKUP." So, this shows that the feature "One Dimensional" applies only to those two formula circles.

Like this, we can create a relationship between two or more similar things using Venn diagrams.

Things to Remember

  • The built-in Venn diagram does not support all kinds of diagrams for relationship creation.
  • For our own needs, we need to draw Venn diagrams through shapes.
  • We can format shapes with different colors and sizes.