How to Make a Venn Diagram in Excel (3 Easy Ways)

Looking for ways to know how to make a Venn Diagram in Excel? Sometimes, we want to make a Venn Diagram from a given dataset in Excel. Here, you will find 3 ways to make a Venn Diagram in Excel.


Download Practice Workbook


3 Ways to Make a Venn Diagram in Excel

Here, we will show you how to make a Venn Diagram in Excel using SmartArt, Scatter Plot, and adding Shapes.


1. Using SmartArt Feature to Make a Venn Diagram in Excel

In the first method, we will show you how to make a Venn Diagram using SmartArt in Excel. Go through the steps given below to do it on your own.


Step-01: Adding SmartArt to Make a Venn diagram

Here, we have a dataset containing the names of players who will play Basketball, Football and Baseball. Now, we will use this dataset to show you how to add SmartArt in Excel to make a Venn Diagram.

Adding SmartArt to Make a Venn diagram

Follow the steps given below to do it on your own.

  • Firstly, go to the Insert tab >> click on Illustrations >> select SmartArt.

  • Now, the Choose a SmartArt Graphic box will open.
  • Then, go to the Relations option.
  • After that, select Basic Venn.
  • Next, click on OK.

Adding SmartArt to Make a Venn diagram

  • Now, a Venn Diagram will be added in Excel.

  • Then, click on the “>”sign.
  • Next, type any Text you want to add in the Type box.

Adding SmartArt to Make a Venn diagram

  • Here, we will type Basketball in the box to add a Name to the 1st circle.

  • Similarly, add names such as Baseball and Football to other circles.

Adding SmartArt to Make a Venn diagram


Step-02: Formatting Venn Diagram

Next, we will show you how you can Format this Basic Venn Diagram. Go through the steps given below to do it on your own.

  • In the beginning, select the Venn Diagram and Right-click on it.

Formatting Venn Diagram

  • Then, click on Color.
  • After that, select any color of your preference. Here, we will select Colorful Range – Accent Colors 2 10 3.

  • Next, go to the Insert tab >> click on Text >> select Text Box.

Formatting Venn Diagram

  • Then, type the Names of the players who played only Basketball.

  • Now, select the text.
  • After that, go to the Home tab >> select 8 as Font Size >> select Middle and Center as Alignment.

Formatting Venn Diagram

  • Again, select the Text box and Right-click on it.
  • Then, click on Format Shape.

  • Now, the Format Shape box will appear.
  • Next, select No fill as Fill.

Formatting Venn Diagram

  • Then, you will see that the Text box has no fill color.

  • Similarly, add other Text boxes containing the Name of the Players.
  • Finally, you will get a Venn Diagram using SmartArt in Excel.

Formatting Venn Diagram

Read More: Create an Organizational Chart in Excel from a List


Similar Readings


2. Use of Shapes Options to Make a Venn Diagram in Excel

We can also make a Venn Diagram in Excel by adding different kinds of Shapes. Here, we will show you how to make a Venn Diagram using Oval.


Step-01: Inserting Shapes to Make a Venn Diagram

Firstly, we will show you how to add Shapes to make a Venn Diagram. Go through the steps to do it on your own dataset.

  • In the beginning, go to the Insert tab >> click on Illustrations >> from Shapes >> select Oval.

Adding Shapes to Make a Venn Diagram

  • After that, add an Oval in Excel.

  • Then, to add another Oval, select the Oval and press CTRL+C to copy the shape.
  • Next, Press CTRL+V to paste it.
  • Similarly, add another Oval.

Adding Shapes to Make a Venn Diagram

  • After that, rearrange the Shapes like a Basic Venn Diagram.


Step-02: Formatting Shapes to Make a Venn Diagram

Now, we will show you how to Format the Shapes to make a Venn Diagram. Follow the steps given below to it on your own.

  • Firstly, select any Oval and Right-click on it.
  • Then, select Format Shape.

Formatting Shapes to Make a Venn Diagram

  • Now, the Format Shape box will open.
  • After that, from Fill options click on Color.
  • Then, select any color of your preference. Here, we will select Green, Accent 6, Lighter 60%.

  • Next, insert 50% as Transparency.

Formatting Shapes to Make a Venn Diagram

  • Now, you will have a Shape formatted like the image given below.

  • Similarly, change Fill color and Transparency of the other two Shapes according to your preference.

Formatting Shapes to Make a Venn Diagram

  • After that, select any of the Ovals and Right-click on it.
  • Then, click on Edit Text.

  • Now, type Basketball as the Label of the Oval.

Formatting Shapes to Make a Venn Diagram

  • Next, select the text.
  • Then, Bold the text.
  • After that, select 14 as Font Size, Middle as Alignment and Black, Text 1 as Font Color.

  • Now, you will get a Label added to the Shape.

Formatting Shapes to Make a Venn Diagram

  • Similarly, add Labels to the rest of the Shapes.

  • Then, add the Names of the Players using Text Boxes by going through the steps shown in Method 1.
  • Finally, you will get a Venn Diagram adding Shapes in Excel.

Formatting Shapes to Make a Venn Diagram

Read More: How to Make a Modified Box Plot in Excel (Create and Analyze)


3. Use of Scatter Plot to Make a Venn Diagram

In the final method, we will use Scatter Plot to make a Venn Diagram in Excel. Go through the steps given below to do it on your own.


Step-01: Preparing Chart Data

Here, we have a dataset containing the name of the Subjects, No of Students Passed and their Relative Size of some students. Now, we will show you how to prepare the data of the Chart to make a Venn Diagram.

Preparing Chart Data

Follow the steps given below to prepare your own dataset.

  • In the beginning, calculate the Chart Value using the formulas shown in the image below.

  • Then, insert the X Value and Y Value for Maths, Physics and Chemistry according to your preference. You can edit the values if needed later on.

Preparing Chart Data

  • After that, select Cell H5.
  • Now, insert the following formula.
=200*D5

  • Next, Press ENTER.
  • Then, drag down the Fill Handle tool to AutoFill the formula for the rest of the cells.

Preparing Chart Data

  • Finally, you will get all the values of the Circle Size.


Step-02: Inserting Scatter Plot to Make a Venn Diagram

Now, you will find way how to insert a Scatter Plot to make a Venn Diagram in Excel.

  • Firstly, go to the Insert tab >> click on Scatter Plot >> select  Scatter.

Inserting Scatter Plot to Make a Venn Diagram

  • Then, click on Select Data.

  • Now, the Select Data Source box will open.
  • After that, click on Add.

Inserting Scatter Plot to Make a Venn Diagram

  • Then, the Edit Series box will open.
  • After that, select Cell B5 as Series name, Cell F5 as X Value and Cell G5 as Y Value.
  • Next, click on OK.

  • Again, click on Add to add the data of Physics and Chemistry.

Inserting Scatter Plot to Make a Venn Diagram

  • Now, add the values of Physics and Chemistry going through the same steps shown above.
  • Then, click on OK.


Step-03: Formatting Scatter Plot

Next, we will show you how to Format the Scatter Plot to make a Venn Diagram. Follow the steps given below to do it on your own.

  • Firstly, double-click on the Y- axis.

Formatting Scatter Plot

  • Now, the Format Axis box will appear.
  • Then, insert 100 as Maximum Bounds.

  • After that, double-click on the X-axis.

Formatting Scatter Plot

  • Again, the Format Axis box will appear.
  • Then, insert 100 as Maximum Bounds.

  • Next, click on the “+” sign to get the Chart Elements.
  • Afterward, turn off Axes and Gridlines.

Formatting Scatter Plot

  • Then, double-click on the point representing the value of Maths.

  • Now, the Format Data Series box will open.
  • Then, click on the box shown below.
  • After that, go to the Marker Options >> select Built-in.

Formatting Scatter Plot

  • Next, insert 50% as Transparency and 200 pt as Width which is the Circle Size for Maths.

  • Then, click on Color >> select Blue, Accent 5, Lighter 60%.

  • Now, you will get a Circle representing the value of Maths.

  • Similarly, create circles using the values for Physics and Chemistry.

Formatting Scatter Plot

  • After that, click on the “+” sign to get the Chart Elements.
  • Then, click on Data Labels >> select More Options.

  • Now, the Format Data Labels box will open.
  • Next, turn on Value From Cells.

Formatting Scatter Plot

  • Then, the Data Label Range box will appear.
  • After that, select Cell B5 as Data Label Range.
  • Next, click on OK.

  • Now, turn off the Y Value from Label Options.

Formatting Scatter Plot

  • Then, select the text.
  • After that, click on Bold.
  • Next, set 20 as Font Size.

  • Thus, you will get Maths as the Label.

  • Similarly, add Labels for Physics and Chemistry.
  • Finally, you will get a Venn Diagram using Scatter Plot in Excel.

Formatting Scatter Plot

Read More: How to Set Intervals on Excel Charts (2 Suitable Examples)


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 3 ways to make a Venn Diagram in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo