How-to-Create-a-Venn-Diagram-in-Excel

How to Create a Venn Diagram in Excel?

by

Excel can be used to solve various mathematical or data related problems. Moreover, those solutions can be displayed or illustrated in the form of charts or graphs which are dynamic.

There is a tool in excel which is called smart charts which can also be used to illustrate diagrams, processes, matrices, etc.

One such key diagram is known as the Venn Diagram.

So, today we will see how to create a Venn Diagram in excel.

What is a Venn Diagram?

A Venn Diagram uses circles to illustrate the relationship among a group of things or otherwise known as sets.

Venn Diagram is used to show commonality between sets. Overlapping circles show commonality while individual circles show distinct characteristics of a group.

In excel, you can make a Venn Diagram to better visualize different traits of particular groups.
So, let’s see how to create a Venn Diagram in excel.

How to Create a Venn Diagram in Excel?

If you have to make sets of students who play games and want to find out which players play two or more games. Venn diagrams can be a good tool to visualize that.

You can do that in excel by creating a Venn diagram.

Step#1 Create the Sets

First, create a table that shows the list of students.

Create-the-Sets

Step#2 Create the Circles for the Venn Diagram

From the “Insert” ribbon go to “Shapes” and select the oval shape.

Create-the-Circles-for-the-Venn-Diagram

Now holding CTRL+SHIFT, use your left click to create a perfect circle. Then select the circle and press CTRL+D twice to make duplicates of the circle.

After that, select the three circles together by pressing the CTRL key and go to “Shape Formats.”

Then from “Fill & Line” increase the transparency of the circles by 50%.

Create-the-Circles-for-the-Venn-Diagram-2

Now, individually change the colors of the circles. Select a circle and then right click to Fill with your preferred color.

Create-the-Circles-for-the-Venn-Diagram-3

Step#3 Using Word Arts to Create the Names in the Sets

Now position the circles as your preference.

Note: You can press the CTRL key and drag use the dots on the outline of the circle to reshape and resize the circles as you wish.

To input the names, you have to create Word Arts.

From, “Insert” ribbon go to “Word Art.”

Using-Word-Arts-to-Create-the-Names-in-the-Sets

Then from the “Home” ribbon decrease the size of the fonts to 12.

Using-Word-Arts-to-Create-the-Names-in-the-Sets-2

Now, press CTRL+D to duplicate and write the names.

Step#4 Inputting the Names in the Venn Diagram

Now determine the relationships and drag the word arts to their right places inside the circles.

Inputting-the-Names-in-the-Venn-Diagram

There you go, your Venn diagram is ready.

There is a tool in Excel called the Smart Charts. You can make a Venn Diagram from there as well.

From, “Insert” ribbon go to “Smart Chart.” You will see a dialogue box pop up.

Inputting-the-Names-in-the-Venn-Diagram-2

Then from “Relationships” select your preferred Venn Diagram.

Inputting-the-Names-in-the-Venn-Diagram-3

But as you can see, you can’t denote the commonality in this diagram. Because you can’t place any common traits inside the common space of the circles.

Inputting-the-Names-in-the-Venn-Diagram-4

However, you still can use it if you wish for other purposes. If you want more circles just press enter and excel will add a new circle to the already existing three circles.

Conclusion

It is very difficult and time-consuming to create a dynamic Venn Diagram. It is a very advanced feature of the scatter plot in Excel.

But this manual Venn Diagram is easy to develop and, in most cases, works.

So, there you go, now you know how to create a Venn Diagram in Excel.

Related Article:

Leave a Comment