WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Venn Diagram

Excel Venn Diagram

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

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

  1. Create a Venn Diagram using Excel Smart Art
  2. Create Venn Diagram Using Excel Shapes
You can download this Venn Diagram Excel Template here – Venn Diagram Excel Template

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

#1 Create a Venn Diagram Using Excel Smart Art

  • Step 1: Go to the Insert tab and click on Smart Art.

Venn Diagram Example 1

  • Step 2: Now, we can see the below smart art window.

Venn Diagram Example 1-1

  • Step 3: Now, select the “Relationship” category.

Venn Diagram Example 1-2

  • Step 4: Scroll down and select “Basic Venn Diagram.”

Venn Diagram Example 1-3

  • Step 5: Once the selection is done, now we will have below the Venn diagram.

Venn Diagram Example 1-4

  • Step 6: Now, click on “Text” to enter the text as VLOOKUP, HLOOKUP, INDEX + MATCH.

Venn Diagram Example 1-5

Now, this diagram shows that all three formulas belong to one category, i.e., LOOKUP Functions.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 7: Now, we can play around with the formatting of the smart art under the “Design” tab. Click on “Design” tab >> Change Colors.

Design - change colors

Step 8: Change the color as per your liking.

Venn Diagram Example 1-7

Like this, we have many Venn Diagram examples; based on our requirement, we can choose different Venn Diagrams.

different types of excel Venn Diagrams

#2 Create Venn Diagram Using Shapes in Excel

  • Step 1: 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, draw an oval shape.

Venn Diagram Example 2-1

  • Step 3: Like this, draw two more oval shapes in the form of a Venn Diagram. Make the fill as no fill.

Venn Diagram Example 2-2

  • Step 4: Now insert Text boxes for each circle.

VennDiagram Example 2-3

  • Step 5: I have inserted 5 text boxes. Now in the first box, I will write VLOOKUP; in the Second box, I will write INDEX + MATCH; in the third box, I will write HLOOKUP.

VennDiagram Example 2-4

  • Step 6: We have another two boxes; you must be wondering what do we need to write with these boxes. In the middle text box, write “LOOKUP Functions,” and in the other box, write it as “One Dimensional.”

VennDiagram Example 2-5

  • Step 7: Now, from this diagram, we can make the interpretation as there are three formulas VLOOKUP, HLOOKUP, and INDEX + MATCH; all these are Lookup function so related to each other.

That is where our middle text box Lookup Function in excel, which belongs to all the circles.

VennDiagram Example 2-6

Then we have one more box which says “One Dimensional” this applies only to the boxes “VLOOKUP & HLOOKUP,” so this shows that the feature “One Dimensional” is applicable 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 doesn’t support all the 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.

Recommended Articles

This has been a guide to Venn Diagram in Excel. Here we discuss how to create a Venn Diagram Using Smart Art and shapes in Excel with examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Venn Diagram Examples
  • Download Fishbone Diagram Template
  • Extract Data from PDF to Excel
  • Box and Whisker Plot in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Venn Diagram Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More