How to create the Venn diagram in Excel?



Introduction

Microsoft Excel is an efficient tool that is used to create interactive charts that more precisely visualize the data. Professionals are said to utilize charts as a tool for graphically communicating ideas or sharing data. Among them, the Venn diagram facilitates the relationships between the defined data in the given range or items that consist of three circles by default, each of which specifies the column data. In this article, we will learn how to insert the basic Venn diagram into the Excel worksheet.

To Insert the Venn Diagram in Excel

Step 1

Deliberate an Excel sheet, switch to the "Insert" tab, and then click on the "Illustrations" tile, and then click on the "SmartArt" option.

SmartArt ?Change Colors' option open, allowing users to adjust the color scheme of the Venn diagram

Step 2

Once the user clicks on SmartArt, another dialog box named "Choose a SmartArt Graphic" will appear on the screen. Select the "Relations" section and then choose the "Basic Venn" option and then click on "OK" as shown below ?

Final formatted three?circle venn diagram in excel with semi?transparent colors and labels

Step 3

Therefore, the Venn diagram is displayed in the specified worksheet, delete the [Text] part from this diagram. The resultant Venn diagram is shown below ?

SmartArt format tab selected, showing shape formatting options for customizing Venn diagram circles

Step 4

Suppose users wish to add the Triangle shape to the Venn diagram. To achieve this, switch to the Insert tab, select the "Illustrations" tile, click on the "Shapes" tile, and then choose the "Triangle" option as highlighted in the below image.

SmartArt Design tab showing change colors dropdown to customize venn diagram circle colors

Step 5

Now, simply drag the triangle to the Venn diagram as shown below ?

Inserted simple two?circle Venn diagram SmartArt graphic displayed in worksheet

Insert the List of Players Along With Their Respective Games in the Venn diagram

Step 1

You must create a table comprising three columns heading "Cricket", "Hockey" and "Badminton" and write the following players' names in this table ?

Venn diagram SmartArt with placeholder text in each circle and intersection area editable

Step 2

Move to the "Insert" tab, go to the "Illustrations" tile, and then choose the "SmartArt" option.

Customized Venn diagram with distinct semi-transparent colors applied to each circle for clarity

Step 3

Once the user clicks on SmartArt, another dialog box named "Choose a SmartArt Graphic" will appear on the screen. Select the "Relations.." section and then choose the "Basic Venn" option and then click on "OK" as shown below ?

SmartArt dialog open in excel with ?Basic Venn' option highlighted under relationship category

Step 4

The Venn diagram would be embedded in the worksheet. Click on the Text area and give the proper heading "Cricket", "Hockey" and "Badminton" in these circles.

Resized and formatted Venn diagram displayed in excel worksheet with proper spacing and alignment SmartArt Tools Design tab open with Quick Styles gallery for applying visual styles to venn diagram

Step 5

Now, we must add the team members in these respective circles. To accomplish this, click on the "Insert" tab and then select the "Text" tile, choose the "Text Box" option and drop it just below all the game headings and the common area as given below.

Three-circle venn diagram in excel with formatted intersections and labeled segments Excel worksheet showing finalized venn diagram with adjusted shape size and text alignment

Step 6

Now, write the entries of the individual team members who played only "Cricket" and fill in the required color to the textbox for more visibility. Note that, Daniel and Harry are common players who played all games. So, these names would come in the common area of the Venn diagram.

Final Venn diagram in excel with styled text and color formatting for clear data visualization

Step 7

Repeat the similar steps for the remaining two games, list the names of team members in the respective textboxes of the other circles adjust the font size, and expand the size of the circles. Daniel and Harry are the players who played all three games. Enter their name in the textbox in the common area of all three games.

Venn diagram in Excel with labeled data sets A, B, and C demonstrating overlaps

Conclusion

It would be concluded that the users may swiftly add the interactive Venn diagram in the given worksheet and integrate the list of players into the defined section. It permits users to interact with the data and enhances the visibility and readability of the dataset.

Updated on: 2023-12-22T11:44:47+05:30

935 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements