Drawing Venn Diagrams in Excel (2 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Drawing Venn Diagrams in Excel

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).

Drawing Venn Diagrams in Excel

  • 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.

Drawing Venn Diagrams in Excel

  • 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.

Drawing Venn Diagrams in Excel

  • Next, assign the unique data (i.e. Hopper, Lilly, Milford, Stephen, Stuart) to the shapes.

Drawing Venn Diagrams in Excel

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.

Drawing Venn Diagrams in Excel

  • 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.

Drawing Venn Diagrams in Excel

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.

Dataset to Create Venn Diagram from Excel Pivot Table

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.

Create Pivot Table in Excel from Venn Diagram

  • 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.

Pivot Table Dialog Box in Excel

  • 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.

Excel Pivot Table Creation

  • Similarly, place Item to Columns area and Quantity to Values area.

Pivot Table Field in Excel

  • 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.

Pivot Table in Excel

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

Rafiul Hasan
Rafiul Hasan

Hey there! I am Md. Rafiul Hasan. Currently, I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our work time and made it easy for us to perform quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo