Excel 2013 can't create automatically out of data, the way it can create and , 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.
Open the Insert tab and click SmartArt.
Select the Relationship category and pick the Basic Venn diagram. Click OK.
Click Add Shape on the Design tab to add additional circles to the diagram.
Video of the Day
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.
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.
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.
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.