How to Make a Venn Diagram in Excel

Google Sheets is a perfectly suitable application in G suite for creating Gantt charts and make it easy to share project schedules in your project team. However, you’d have to use the time-consuming features to make a Gantt chart, which is less efficient than in professional tools.

How would you like to create your Venn Diagram?

How to Make a Venn Diagram in Excel

Using SmartArt Shapes

Step 1: Open SmartArt Graphic Window

Go to the Insert tab of a new worksheet, click the SmartArt button on the Illustrations group to open the SmartArt Graphic window.

smartart graphic window

Step 2: Insert a Venn Diagram

Under the Relationship category, choose Basic Venn and click OK. Then the Venn diagram is added on the sheet.

Click on the arrow icon next to the diagram to open the Text pane. You can paste or type the text or numbers on the Text pane.

To add text or numbers on the crossed sections, draw text boxes onto the circles.

add text

Step 3: Add Circles to Venn Diagram

To add more circles to the Venn diagram, click to select the whole diagram at first, then you can try the following 2 ways:

add circle
  1. Go to the Design tab of SmartArt Tools, click Add Shape button on the Create Graphic
  2. On the Text pane, select a bullet, press Enter to add a new one and a blank circle will be added on the diagram.
insert stacked bar graph

Similarly, these circles can be deleted by clicking on the shape or its corresponding bullet and pressing Delete.

Step 4: Style Your Venn Diagram

To style the Venn diagram in Excel, there are many different formatting tools:

    1. Go to the Design and Format tab Of SmartArt Tools where you can change diagram layouts, colors, styles, etc.
    2. Right-click on the circle, select Format Shape on the context menu, and then you can change the fill style, fill color or another option.
format shape
  1. The right-clicking menu also provides other quick options, like Change Shape, Add Shape, or Reset Shape.
Using Regular Shapes

If you have no access to SmartArt Graphics, you can manually create a Venn diagram by drawing circles.

Like adding SmartArt graphics, click the Shape button under the Insert tab, and pick the shape of Oval from the shape gallery. Then you can draw a lot of circles on the sheet.

shape gallery

Do remember that you need to increase the fill transparency of each circle in the Format Shape pane, otherwise, the overlapping sections of circles will be invisible.

manually add circles

How to Make a Venn Diagram in EdrawMax

Excel is a very powerful tool in processing data, however, it still has many limitations on drawing diagrams. Here, EdrawMax is comparably suitable for drawing and creating various professional-looking diagrams, including Venn diagrams.

Step 1: Pick Venn Diagram Templates

When you want to add a Venn diagram in your presentation, using a stunning and unique template will be of great help.

Open (EdrawMax Online), find Venn Diagram in the Basic Diagram menu, and you’ll see plenty of Venn diagram templates in the template gallery.

edrawmax venn template

Step 2: Use a Venn Template

Pick one of the Venn diagram templates that you want to use, click on its thumbnail and the template will be opened on a new webpage. Then you can add text or numbers on the template directly.

edrawmax open template

Step 3: Add Shapes Manually

To add shapes manually in EdrawMax, click on the Symbol Library icon edrawmax symbol library icon to open Library dialog box, then tick Venn Chart under the Diagram category and click OK.

The shapes and symbols of Venn diagrams will show up on the Library pane. All shapes and symbols on the Library pane can be directly dragged and dropped on the drawing page.

edrawmax add venn shapes

Step 4: Customize Your Venn Diagram

To customize your Venn diagram in EdrawMax, there are also many different choices:

  1. Change shape styles and colors on the Fill/Line/Shadow
  2. Change background colors on the Page Setup
  3. Change diagram themes on the Theme
right side pane

Step 5: Present Your Venn Diagram

Click the Play button on the upper right corner of the main interface, and the Venn diagram will be displayed on the full-screen mode, just like that you are making a presentation.

upper right button

How to Save an Edraw Diagram as an Excel File

In the end, when you finish making your Venn diagram in EdrawMax, you will find that EdrawMax supports users to save and export the document in multiple places and in different file formats.

Go to the File tab, click Save As and then you can choose to save your diagram in Edraw personal cloud, Google Drive or Dropbox. Thus, you are able to access the documents from anywhere.

Click on Export and you can choose to export the document in the format of MS Excel. Besides, all MS Office files exported from EdrawMax can be opened and edited in the corresponding programs, which will be more convenient for you to share your creations and designs with others.

edrawmax export excel
download EdrawMax EdrawMax online
main page