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.

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

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

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

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

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

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

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

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

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

**Similar Readings**

**How to Make Sankey Diagram in Excel (with Detailed Steps)****How to Make a Box Plot in Excel (With Easy Steps)****If a Value Lies Between Two Numbers Then Return Expected Output in Excel****How to Create Butterfly Chart in Excel (2 Easy Methods)**

### 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**.

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

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

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

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

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

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

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

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

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.

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

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

- Then, click on
**Select Data**.

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

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

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

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

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

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

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

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

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

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

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

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

## 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

**How to Add Trailing Zeros in Excel (2 Easy Ways)****Calculate WACC in Excel (with Easy Steps)****How to Make a Dot Plot in Excel (3 Easy Ways)****Do Descriptive Statistics in Excel (2 Suitable Methods)****Make Trial Balance in Excel (with Easy Steps****How to Calculate APR in Excel (3 Simple Methods)****How to Make a Forest Plot in Excel (2 Suitable Examples)****Make Fishbone Diagram in Excel (with Easy Steps)**