Venn Diagram in Excel
Although Excel is primarily spreadsheet software, it does allow for some basic diagram creation. This page explains how to create Venn diagrams in Excel 2013 to complement your spreadsheets.
For a program designed specifically for venn diagrams, try Lucidchart, an online Venn diagram tool. With free educational accounts, and free templates for 3 circle venn diagrams, 4 circle venn diagrams, and 5 circle venn diagrams, you can get started right away!Try it now Sign up free
Before you begin
Before starting, open a blank Excel workbook. You may want to try clicking the Ribbon Display icon to adjust your display settings. Choosing a cleaner interface from this menu will make it easier to diagram.
Next, write down a list of each category you want to capture in the spreadsheet columns. For this example, we'll use the categories “Movies with Meg Ryan” and “Movies with Tom Hanks.”
PICK A TEMPLATE
To pick your diagram template, click the Insert tab and choose SmartArt. SmartArt provides users with pre-made groups of shapes with built-in logic. These shapes include rudimentary Venn diagram templates.
If you choose SmartArt:
- When you select SmartArt, a dialog will pop up. Scroll down through the left panel and choose the Relationship shape library. From there, you can pick from several Venn diagram templates. The smallest diagram is a three-circle version, which we will choose for this guide.
ADD OR DELETE CIRCLES
You can add or delete circles from an existing diagram using the Design tab on the top menu bar. Click on the diagram and choose Add Shapes to make more circles.
To delete a circle, click on it and choose Delete from the Design tab.
Once you have the number of circles you want, simply double-click the text to label each circle. In this case, we'll label our circles with two categories: “Movies with Tom Hanks” and “Movies with Meg Ryan.” You can adjust the font options on the labels in the dialog box that pops up automatically.
To include additional text in this diagram beyond your labels, you’ll need to draw text boxes onto the circles.
Once you've drawn them where you want them, fill in these boxes with movies from the two columns. Make sure the text is sized correctly, so everything fits where it belongs.
In this example, we’ve put Tom Hanks movies on one side of the diagram and Meg Ryan on the other. Those movies that they’ve both starred in are included in the middle, overlapping area of the diagram.
COMPLETE YOUR DIAGRAM
Complete the diagram by adding all of your text in the appropriate subsections. If you decide to change the style of your diagram, just return to the Design tab to add circles or modify the structure. Be careful, though; the text you’ve added will not automatically snap to shapes and you may end up with an odd-looking diagram.
MAKE A VENN DIAGRAM IN LUCIDCHART
Making a Venn diagram in Lucidchart is effortless because everything is completely customizable. When you need to add text, you can drag out whole chunks rather than drawing small boxes and hoping they line up. We provide free, customizable templates like the one below, which include both built-in shapes for category and shape text boxes. Try our templates for yourself and discover the fun of Venn diagrams.Click to open
ADD A LUCIDCHART DIAGRAM TO EXCEL
To embed your flowchart into Microsoft Excel, click File > Download As. Select the image file type you prefer, indicate which areas of the document you want to download, then hit the download button.
Open a blank workbook in Excel. Then click the Insert tab and select Pictures. Find the image you downloaded and click Insert to add your diagram.
USEFUL FEATURES IN LUCIDCHART
Lucidchart provides many useful features that make online diagramming a cinch. Drag-and-drop technology, optional snap-to-grid settings, and pop-up menus all simplify the process. Plus, you can create much more than Venn diagrams. Try your hand at making flowcharts, org charts, UML, and more, all for free. If you’d like to experiment with mind maps or mockups, you can upgrade to a premium account at any time.Try it now Sign up free