Examples of Venn Diagram in Excel
A Venn diagram is one kind of chart in Excel that is used in the analysis of the relationship presented among the two or more groups through intersecting parts of the circles. The intersecting circles are helpful in illustrating the differences, similarities, and relationships among the various groups, categories, ideas, and concepts. Non-overlapping parts are used to illustrate the differences, while overlapping parts are used to illustrate the similarities. In Venn diagrams, each group is represented by one circle. It is easy to create, use, and edit the Venn diagrams as per the user requirements. This article covers the examples of a Venn diagram of various types.
Top 4 Examples of Venn Diagrams in Excel
Below are the examples of the Venn diagram in excel.
Venn Diagram – Example #1
Basic Venn diagram with two circles.
The following steps are followed for creating the basic Venn diagram.
Step 1: Open the Excel workbook.
Step 2: Note down the group of categories that you want to capture into the Venn diagram
Step 3: Go to the “Insert” tab and click on the “Smart Art.”
Choose a SmartArt Graphic dialogue box that will be opened, as shown in the figure.
Step 4: Select the Relationship category and Choose the basic Venn diagram.’
The diagram is inserted, as shown in the figure.
Step 5: I want only two circles. Remove one circle by selecting and clicking on the delete option.
Step 6: Add content to the non-overlapping circles. This can be done in three ways.
- Click on the “Text pane” and add content next to the bullet points.
- Copy content from another place and directly paste it into the “text pane.”
- Click directly into the circles and add content to them.
To add content into the circles, use the “Text Box,” as shown in the figure, and apply formatting to circles to enhance the appearance.
Step 7: Add content into the Overlapping part of the circles
The overlapping part indicates that the whale belongs to both categories, including Mammals and Animals living in the water.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Venn Diagram – Example #2
Basic Venn diagram with Three Circles
Consider an example that 40 students of a class speak different languages create a Venn diagram with 3 circles for the same.
10 students speak only English and Hindi but not Urdu. 6 students speak only Hindi and Urdu but not English, 2 students speak English and Urdu but not Hindi, 2 Students speak all three languages, 1 student speaks only Hindi, 9 students speak only English, and 10 students speak only Urdu.
The following steps are followed for creating the basic Venn diagram with 3 circles for this example.
Step 1: Open the Excel workbook
Step 2: Note down the group of categories that you want to capture into the Venn diagram
Step 3: Go to the “Insert” tab and click on the “Smart Art.” Select the Relationship category and choose the ‘basic Venn diagram.’
The diagram is inserted, as shown in the figure.
Step 4: Enter the three languages Hindi, English, and Urdu, into the non-overlapping circles.
Step 5: add content into the overlapping and non-overlapping portions of the circles to understand the relationship among the three circles.
The relationship among the students speaking different languages is established by the following equation.
Total students (40) = 10+1+9+10+2+2+6
Venn Diagram – Example #3
Stacked Venn diagram
This example illustrates the creation and use of the stacked Venn diagram in Excel to represent the overlapped relationships.
Step 1: Open the Excel workbook.
Step 2: Note down the group of categories that you want to capture into the Venn diagram.
Step 3: Go to the “Insert” tab and click on the “Smart Art.” Select the Relationship category and choose the ‘Stacked Venn diagram.’
Step 4: The diagram will be displayed as shown in the below-mentioned figure
Step 5: Select a diagram and click on the “Text pane” and add content next to the bullet points and apply the required formatting to the Venn diagram.
Step 6: Use the Text box to add content to each concentric circle.
Drag the text boxes to the stacked Venn diagram and place it in research philosophy circles. Similarly, do for remaining circles also. The diagram will be changed a,s shown in the screenshot.
In the above-stacked Venn diagram, the Onion model research process is clearly described. The main purpose of this diagram is to narrow a broad topic of the research process.
Venn Diagram – Example #4
Radical Venn diagram
This example illustrates the creation and use of the Radical Venn diagram in Excel by selecting an example of methods to improve consumer sales.
Step 1: Open the Excel workbook
Step 2: Note down the group of categories that you want to capture into the Venn diagram
Step 3: Go to the “Insert” tab and click on the “Smart Art.” Select the Relationship category and choose the ‘Radical Venn diagram.’
Step 4: The radial Venn diagram will be displayed, as shown in the below-mentioned figure.
Step 5: Click on the “Text pane” and add content next to the bullet points.
Step 6: Add content to the circles regarding the methods used in consumer sales improvement, as shown the figure
If we want to add an extra circle to the diagram, right-click on the diagram and select add shape or press ENTER in the text pane.
Step 7: Add text to newly added circles and modify the diagram.
Step 8: Apply different formats and change the colors of the circles to add more appearance.
From this diagram, it is cleared that the methods mentioned in outer circles must be followed to enhance consumer sales.
Things to Remember
- To place the text box properly into the Venn diagram, drag it to the required place when crossed arrows are displayed
- To apply the format to the text presented in the text box, use the formatting options presented in the “Font” group on the “Home” tab.
- Use the “Design” tab facility to add glow, soft edge, effects, colors, and smart art styles.
Recommended Articles
This has been a guide to Venn Diagram Examples. Here we discuss how to create a Venn diagram with the examples of Basic Venn diagram with 3 circles, Stacked Venn, and Radical Venn diagram. You can learn more about excel from the following articles –
- Animation Chart in Excel
- Create Grouped Bar Chart
- Change Chart Style in Excel
- Create Combo Chart in Excel
- IF AND in Excel
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion