spot_img

How To Insert Venn Diagram In Excel

Follow the steps below to create a Venn Diagram

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

ribbon smart art

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

choise smart art

The Venn diagram will appear. 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

(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

Note: To customize your Venn diagram use the Design tab

Template

You can download the Template here – Download
spot_img
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial