Venn Diagram Excel (Table of Contents)
Excel Venn Diagram
Venn Diagrams are one of the important questions in all the competitive exams under logical reasoning. Venn Diagrams describes the relationship between two or more set of values which are related to each other one or other way. In this article, we will show you how to create a “Venn Diagram” in excel.
Venn Diagrams are oval-shaped circles which overlaps on each other if one circle relates to another circle. For an example look at the below Venn Diagram.
In the above example, there are two kinds of books, one is “Hard Copy Books” and the second one is “Kindle Books”.
Under “Hard Copy Books” we have 18 numbers and under “Kindle Books” we have 15 books. But the combination of both these books number is 12. So, above Venn Diagram shows the relationship between these two.
How to Create a Venn Diagram in Excel?
Below are the two ways to create a Venn diagram in Excel.
Example #1 – Venn Diagram in Excel through Smart Art
If you are a regular user of Smart Arts in excel then you must have come across the “Venn Diagram” option in that window.
Venn Diagram can be found under Insert tab under Illustrations >> “Smart Art”.
In the smart art window, we can see this diagram under “Relationship” category. In this category, we can see many relationship diagrams, drag down and select the Venn Diagrams at the end.
Go to Insert tab and click on Smart Art.
Now we can see the below smart art window.
Now select the “Relationship” category.
Scroll down and select “Basic Venn Diagram”.
Once the selection is done, now we will have below Venn diagram in Excel.
Now click on “Text” to enter the text as, VLOOKUP, HLOOKUP, INDEX + MATCH.
Now, this diagram shows that all the threes formulas belong to one category i.e. LOOKUP Functions.
Now we can play around with the formatting of the smart art under the “Design” tab. Click on “Design” tab >> Change Colors.
Change the color as per your liking.
Like this, we have many Venn Diagram examples based on our requirement we can choose different Venn Diagrams.
Example #2 – Venn Diagram with Shapes
Even though excel feed me with built-in Venn Diagrams through Smart Arts, often times it doesn’t really fit our requirements. So, to fit our requirements we can insert Venn Diagram through Shapes in excel.
For an example, our lookup functions “VLOOKUP & HLOOKUP” are one dimensional because, VLOOKUP can work from left to right and HLOOKUP can work from Top to Bottom, so this is where INDEX + MATCH are flexible enough to use.
We will try to show this in the Venn Diagram.
Go to Insert tab, click on Illustrations and select shapes then, choose Oval shape.
First, draw an Oval shape.
Like this draw two more oval shapes in the form of Venn Diagram. Make the fill as no fill.
Now insert Text boxes for each circle.
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.
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”.
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 with each other.
That is where our middle text box “Lookup Function” which belongs to all the circles.
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
- Built-in Venn diagram doesn’t support all the kind of diagrams for relationship creation.
- For our own needs, we need to draw Venn Diagrams through shapes in excel.
- We can format shapes with different colors and size.
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 downloadable excel template. You may learn more about excel from the following articles –