Charts and Dashboards: Venn Diagrams Part 1

Welcome back to our Charts and Dashboards blog series. This week, I look at Venn Diagrams.

I have a very simple Table with some annual statistics for my salespeople:

I want a quick visualisation to show which of my salespeople have reached the standards set. These are currently:

• over 50 sales
• at least 99% attendance
• less than two [2] complaints.

I am going to create a Venn Diagram to show which salespeople meet all these conditions. I start by going to the SmartArt option in the Illustrations section of the Insert tab.

I can then choose which type of SmartArt Graphic I want to use from the dialog that appears. I pick the Relationship section:

In the Relationship tab, if I scroll down, there are a number of options for Venn Diagrams. I choose a ‘Basic Venn’.

When I click on this icon, I get more details about the SmartArt Graphic:

I click ‘OK’ and the Basic Venn appears, ready for me to add text:

I enter the requirements for each of the categories that my salespeople are being judged on:

There are however, no automatic text inserts for the overlapping areas. To get around this, I can create a Text Box. I do this from the ‘Text’ group in the Insert tab:

This dropdown allows me to choose ‘Text Box’:

I select this, and choose the position of the new Text Box:

I can type into the Text Box. In this case, Mary has more than 50 sales and less than 2 complaints. I continue to fill the rest of the Basic Venn, and click and drag to enlarge it:

Mary is clearly a star. Next time I will continue to look at how I can format Venn Diagrams.

That’s it for this week. Come back next week for more Charts and Dashboards tips.