How to Make a Venn Diagram in Excel

Follow the steps below to create a Venn Diagram.

Insert a SmartArt Graphic

Launch Excel, click on Insert tab and in the Illustrations group select SmartArt.

ribbon smart art

Insert Venn diagram layout

In the Choose a SmartArt Graphic gallery, click Relationship, click a Venn diagram layout (such as Basic Venn), and then click OK.

choose smart art

The Venn diagram will appear.

Venn diagram formatting

Click on [Text] to add text to your Venn diagram.

venn diagram

To add text to the overlapping parts of the circle:

  • On the Insert tab, in the Text group, click Text Box.
  • Drag to draw a text box.
  • Select the text box and type your text.
  • Position the text box over the overlapping area of the circles.

venn diagram design

The number of circles in a Venn diagram is limited by the options available in the “SmartArt” dialog box.

(optional) To add or delete new circles:

  • Click the SmartArt graphic that you want to add another circle to.
  • Click the existing circle that is located closest to where you want to add the new circle.
  • Under SmartArt Tools, on the Design tab, in the Create Graphic group, click the arrow next to Add Shape.

Do one of the following:

  • To insert a circle after the selected circle, that will overlap the selected circle, click Add Shape After.
  • To insert a circle before the selected circle, that will overlap the selected circle, click Add Shape Before.
  • To delete a circle from your Venn diagram, click the circle you want to delete, and then press DELETE
See also  How to Make Ogive Chart in Excel

Note: To customize your Venn diagram use the Design tab.