Venn diagram is used to show the common and uncommon data under a specific category to show connections between the data and the category. Can you make a Venn diagram in Excel? Are you looking for ways to create one? No worries! In this article, I will try to show you the process of drawing Venn diagrams in Excel.
Let’s say, we have got a dataset of some customers consuming 3 different types of food items (i.e. Burger, Pasta, Pizza). Here, some of the customers tried only 1 type of food item, some tried 2 and some even tried all the 3 items together.
Let’s rearrange the raw data manually to comprehend which person has taken how many types of food items.
We can see that Adam has tried each type of item. The rest of the people, some have tried 2 types and others have tried only one item from the menu.
From this organized data, we want to create a Venn diagram to show which person has taken which food items.
In this section, you will find 2 common methods of drawing Venn diagrams in Excel. I will demonstrate them one by one here with proper illustrations.
1. Using SmartArt Feature
You can apply the SmartArt feature of Excel for creating relational shapes in Excel. Forming this shape will help to create the Venn Diagram.
⏩ Steps:
- First of all, go to the Insert tab> click Illustrations group> select SmartArt icon.
- Then, a dialog box named Choose a SmartArt Graphic will appear in the Excel window. From the menu list, click Relationship group> select Basic Venn from the shapes available> click OK. Our dataset has 3 different types of food items and we want to show the relationship on the basis of food items. And Basic Venn has 3 circles overlapping with one another. So, we have chosen this type. However, you can add circles to your diagram.
- Now, the shapes of Basic Venn as well as a command box with the heading Type your text here will appear in the Excel sheet. If you press ENTER in that command box, fields in that box as well as shapes will be increased.
- After that, type the text in the command box field on the basis of which you want to show the relationship (i.e. Burger).
- As soon as you type text in the field, your shape will hold the text in it as well.
- So, fill the text field to make headings in the shapes of Basic Venn.
- Now, it’s time to show the relationship between the shapes. Go to the Insert tab> click the dropdown of the Text menu> click Text Box.
- Here, insert the Text Box at the intersectional region of the shape as shown in the GIF below.
- After inserting the Text Box, type text in it. From the Pivot Table that we have created, we can see that only one customer (i.e. Mike) has tried all the 3 items. So, this customer (i.e. Mike) will be put in the intersectional region of the 3 shapes describing 3 food items.
- Then, select the text n the text box and right-click on the mouse to format the shape of the text box.
- Clicking the Format Shape option will introduce the Format Shape dialog box at the right corner of the Excel sheet. Choose No fill and No line.
- Hence, the fill color of the text will match the color of the shapes. Now, input relevant data to the intersection of two shapes in the same procedure.
- Next, assign the unique data (i.e. Hopper, Lilly, Milford, Stephen, Stuart) to the shapes.
So, this is the way you can draw Venn diagrams in Excel with the SmartArt Feature.
Read More: How to Do Drawing in Excel Using VBA (5 Ideal Examples)
2. Inserting Shapes
Another method is available for creating a Venn Diagram in Excel. This method is a little bit manual and time-consuming. You have to insert shapes manually for this.
⏩ Steps:
- First, go to the Insert tab> select Illustration> click Shapes> choose a circular type of shape (i.e. Oval).
- Then, draw the shape as described in the GIF below.
- Next, copy the shapes and paste one on another to create shapes of the same sizes.
- The intersectional area can’t be seen here because of the thick region. Right-click on the shapes and click Format Shape to change the format of the shapes.
- After that, from the Format Shape dialog box, increase the transparency and see the change in the shape.
- Similarly, change the fill color and transparency of the other shapes.
- Now, follow these steps of Method 1 to insert the Text Box.
- Then, put the relational data between the intersectional and non-intersectional regions of the shapes and create your Venn Diagram.
Read More: How to Draw Shapes in Excel (2 Suitable Ways)
How to Create Venn Diagram from Pivot Table in Excel
Let’s have a look at our dataset once again.
You may want to create a Pivot Table table to organize the data and then draw a Venn diagram from that Pivot Table. For this, you have to create a Pivot Table first.
⏩ Steps:
- First of all, select a random cell in your dataset> go to the Insert tab> and click on PivotTable.
- Then, a dialog box named PivotTable from Table or range will appear on the worksheet.
- Here, in the Table/Range field, the dialog box will show the range of data that will hold the PivotTable. Remember that you just selected one single cell in your data range, but Excel has recognized all the data ranges for creating PivotTable.
- Now, choose where you want to place the PivotTable (New/Existing Worksheet) in the relevant field and click OK.
- Now, Excel will show PivotTable Fields at the right corner of the worksheet window.
- In the fields, the header of the data table will appear. Our dataset includes 3 columns with header Customer, Item, Quantity.
- Drag the field to the relevant areas. Drag the relevant field to the relevant areas depending on which you want to create the PivotTable. In our case, I want to place Customer in the row, so I dragged this field to the Rows Area.
- Similarly, place Item to Columns area and Quantity to Values area.
- As a result, you will see that data have organized themselves to create PivotTable. Customer names have been placed in Rows and Items have been placed in Columns to count the Quantity as per Customer and Item.
So, now we have created our Pivot Table. After completing the Pivot Table, you can follow either Method 1 or Method 2 for drawing the Venn diagram from the Pivot Table data.
Read More: How to Use Drawing Tools in Excel (2 Easy Methods)
Practice Section
Here, I am providing you with a practice sheet so that you can practice yourself.
📁 Download Practice Workbook
You can download the practice book from the link below.
Conclusion
In this article, I have tried to show you some methods of drawing Venn diagrams in Excel. Hope you like reading the article. If you have any questions, or feedback regarding this article, please don’t forget to share them in the comment box. ExcelDemy team is always responsive to your queries. For more queries, kindly visit our website.
Related Articles
- How to Construct 3D Drawing in Excel (3 Suitable Examples)
- Draw Lines in Excel (2 Easy Methods)
- How to Draw Isometric Drawing in Excel (with Easy Steps)
- Remove Drawing Tools in Excel (3 Easy Methods)
- How to Draw to Scale in Excel (2 Easy Ways)
- Draw Engineering Drawing in Excel (2 Suitable Examples)
- How to Draw a Floor Plan in Excel (2 Easy Methods)