EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Charts Venn Diagram in Excel
Secondary Sidebar
Excel Functions
  • Excel Charts
    • Excel Data Visualization
    • Dashboard in Excel
    • Bullet Chart in Excel
    • Excel Animation Chart
    • Plots in Excel  
    • Interactive Chart in Excel
    • Surface Charts in Excel
    • Excel Calendar Template
    • Thermometer Chart in Excel
    • Box Plot in Excel
    • S CURVE in Excel
    • Venn Diagram in Excel
    • Project Management with Gantt Chart
    • Change Chart Style in Excel
    • 3D Scatter Plot in Excel
    • Box and Whisker Plot in Excel
    • Radar Chart in Excel
    • Control Charts in Excel
    • Dot Plots in Excel
    • Marimekko Chart Excel
    • Combo Chart in Excel
    • Contour Plots in Excel
    • Candlestick Chart in Excel
    • Map Chart in Excel
    • Pie Chart Examples
    • Excel Stacked Bar Chart
    • Excel Flowchart
    • Excel Types of Graphs
    • Excel Normal Distribution Graph
    • Excel Bell Curve
    • Legends in Excel Chart
    • Excel Chart Templates
    • Excel Organization Chart
    • Excel Doughnut chart
    • Excel 3D Plot
    • Excel Scatter Chart
    • Excel Line Chart
    • Excel Combination Charts
    • Excel Gauge Chart
    • Excel Pivot Chart
    • Excel Clustered Column Chart
    • Excel Dynamic Chart
    • Excel Stacked Column Chart
    • Excel Bubble Chart
    • Histogram Chart Excel
    • Excel Gantt Chart
    • Excel Stacked Area Chart
    • Excel Waterfall Chart
    • Excel Area Chart
    • Excel Clustered Bar Chart
    • Excel Column Chart
    • Excel Pie Chart
    • Comparison Chart in Excel
    • Pareto Analysis in Excel
    • Add a Secondary Axis in Excel
    • Grouped Bar Chart
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED COURSE
  • Excel Data Analysis Course
  • Excel for Marketing Course

Venn Diagram in Excel

By Twinkle SethiTwinkle Sethi

Venn Diagram in Excel

Excel Venn Diagram (Table of Contents)

  • Introduction to Venn Diagrams in Excel
  • How to Create Venn Diagram in Excel?

Introduction to Venn Diagrams in Excel

A Venn diagram is a diagram or illustration of the relationships between and among sets (different groups of objects). It is a pictorial representation of logical or mathematical sets that are drawn in an enclosing rectangle (rectangle representing the universal set) as circles.

Each circle represents a set, and the points inside the circle represent the elements of the set. The interior of the circle represents elements that are not in the set. Common elements of the sets are represented as intersections of the circles. Venn diagrams are called so as John Venn invented them.

How to Create Venn Diagram in Excel?

Let’s understand how to Create Venn Diagram in Excel with a few examples.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

You can download this Venn Diagram Excel Template here – Venn Diagram Excel Template

Example #1

Let’s say we wish to draw a Venn diagram for the number of students who passed (out of 25) in the subjects: Maths, English, and Science. We have the following students’ data in an Excel sheet.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,768 ratings)

Venn Diagram in Excel 1-1

Now the following steps can be used to create a Venn diagram for the same in Excel.

  • Click on the ‘Insert’ tab and then click on ‘SmartArt’ in the ‘Illustrations’ group as follows:

Venn Diagram in Excel 1-2

  • Now click on ‘Relationship’ in the new window and then select a Venn diagram layout (Basic Venn) and click ‘OK.

Venn Diagram in Excel 1-3

  • This will display a Venn diagram layout as follows:

Venn Diagram in Excel 1-4

  • Now the text on the circles can be changed by clicking on [Text] in the Text pane in circles and then renaming it so as to depict what the circles represent.

Venn Diagram in Excel 1-5

  • We can add text in overlapping portions of the circles by inserting a text box.

Venn Diagram in Excel 1-6

Example #2

Let’s say there are two sets A & B defined as A= {1, 2}, and B= {2, 3}, and we wish to find A U B (A union B). A union is defined as something that is present in either of the groups or sets.

So A U B means the elements or numbers from either A or B.

  • A U B= {1, 2} U {2, 3}
  • A U B= {1, 2, 3}

So let’s see how this can be represented in a Venn diagram.

  • Click on the ‘Insert’ tab and then click on ‘SmartArt’ in the ‘Illustrations’ group as follows.

Venn Diagram in Excel -Union 1

  • Now click on ‘Relationship’ in the new window and then select a Venn diagram layout (Basic Venn) and click ‘OK.

Venn Diagram in Excel - Union 2

  • This will display a Venn diagram layout as follows.

Venn Diagram in Excel - Union 3

We can also choose ‘Linear Venn’ instead of the ‘Basic Venn’ layout and then delete some circles. Now since there are only two sets (A & B) in this case, we delete one of the circles from the Venn diagram as follows.

  • Click one of the circle and press the ‘Delete’ button. This will lead us to a Venn diagram below:

Venn Diagram in Excel -Union 4

  • Now the text on the circles can be changed by clicking on [Text] in the Text pane in circles and then renaming it so as to depict what the circles represent.

Venn Diagram in Excel -Union 5

Just like Union, there is another term generally used for sets which are ‘Intersection’ which means something that is present in all of the groups or sets.

So, in this case, An intersection B (A ∩ B) would be numbers or elements that are present in both A & B.

  • A ∩ B= {2}

Just like deletion, we can even add circles to the Venn diagram by following the below steps.

  • Right-click the existing circle, which is closest to where the new circle is to be added. Now click on ‘Add Shape’, and then click on ‘Add Shape After’ or ‘Add Shape Before’.

Add shape

After adding the shape, the output is shown below.

Add shape 1

Example #3

Let’s say there are two sets A & B defined as A= {1, 3, 5} and B= {1, 2, 3, 4, 5, 6}, and we wish to find A U B (A union B). So as seen in the above example, A U B means the elements or numbers from either A or B.

  • A U B= {1, 3, 5} U {1, 2, 3, 4, 5, 6}
  • A U B= {1, 2, 3, 4, 5, 6}

So let’s see how this can be represented in a Venn diagram.

  • Click on the ‘Insert’ tab and then click on ‘SmartArt’ in the ‘Illustrations’ group as follows.

Illustrations 3-1

  • Now click on ‘Relationship’ in the new window and then select a Venn diagram layout (Stacked Venn) and click ‘OK.

Illustrations 3-2

  • This will display a Venn diagram layout as follows.

Stacked Venn 1

Now since there are only two sets (A & B) in this case, so we delete the extra circles from the Venn diagram by right-clicking on them and pressing ‘Delete’. This will lead us to a Venn diagram as below.

Stacked Venn 2

A is a subset of B, so if B represents the outer circle, A will represent the inner circle. Also, since all the elements of A are also present in B, so we can reposition the inner circle by dragging it.

Stacked Venn 3

In this case, A U B will be equal to B as A is a subset of B. Also, A U B will be equal to A.

Things to Remember About Venn Diagram in Excel

  • Venn diagrams illustrate simple set relationships. They are generally used in probability, statistics, computer science, and physics.
  • Overlapping circles are used in Venn diagrams to show the similarities, differences, and relationships between different group of objects. The overlapping portions represent the similarities between groups, and the non-overlapping portions represent the differences.
  • Venn diagrams enable us to organize information visually so as to see relationships between two or more set of items. Venn diagram can also be created via drawing tools available in Excel.
  • We can even apply a SmartArtStyle to the Venn diagram. To do this, click on the ‘Design’ tab in the “SmartArt Tools and then click on the layout that is desired :
  • We can even apply color combinations to the circles in the Venn diagram and change their colors as desired. Also, we can add soft edges, glows, and 3D effects. To do this, click on the ‘Design’ tab in the “SmartArt Tools and then click on ‘Change Colors’ and select the desired color theme:

Recommended Articles

This is a guide to Venn Diagram in Excel. Here we discuss creating Venn Diagrams in Excel and practical examples, and a downloadable excel template. You can also go through our other suggested articles –

  1. Dot Plots in Excel
  2. Family Tree in Excel
  3. Marimekko Chart Excel
  4. Interactive Chart in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Data Analysis Training (17 Courses, 8+ Projects)4.9
Excel for Marketing Training (8 Courses, 13+ Projects)4.8
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
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

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

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

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Venn Diagram Excel Template

EDUCBA

Download Venn Diagram Excel Template

EDUCBA

डाउनलोड Venn Diagram Excel Template

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

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more