Charts and Dashboards: Venn Diagrams Part 1
24 December 2021
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  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.