How to Create a Venn Diagram in Excel or Word

Excel 2013 can't create Venn diagrams automatically out of data, the way it can create line graphs and pie charts, but you're not out of luck: the SmartArt tool helps to build diagrams, including Venn diagrams. As a universal Microsoft Office feature, SmartArt works in most Office programs. Whether you're working in Word, Excel or even Outlook, the steps to create a Venn diagram are almost exactly the same.

Step

Open the Insert tab and click SmartArt.

SmartArt on Insert tab.
credit: Image courtesy of Microsoft
Relationship diagrams.
credit: Image courtesy of Microsoft

Step

Select the Relationship category and pick the Basic Venn diagram. Click OK.

Graphic design options.
credit: Image courtesy of Microsoft

Step

Click Add Shape on the Design tab to add additional circles to the diagram.

Text pane.
credit: Image courtesy of Microsoft

Step

Type in the text pane to enter text inside each circle. As you type, Office adjusts the font size and positioning, so you don't need to worry about fitting long lines of text into the diagram.

Add overlap text boxes.
credit: Image courtesy of Microsoft

Step

Switch to the Insert tab and click Text Box. If using Word or Outlook, click Draw Text Box. Click and drag to draw a text box on an overlapping area between circles or anywhere else you want to add text.

Text box formatting.
credit: Image courtesy of Microsoft

Step

Right-click the border of a text box and choose Format Shape. Set the Fill to No Fill and the Line to No Line to remove the white square, placing your text directly on the diagram. Repeat for each text box.

Colors and styles.
credit: Image courtesy of Microsoft

Step

Select the diagram, switch back to the Design tab and click Change Colors to pick a color scheme. Pick a style from the SmartArt Styles section.