Tag Archives: Venn diagram

How to create a Venn diagram in Excel

Excel has a Venn diagram option in its SmartArt but three pretty identical circles doesn’t do it for me. When the sizes of the circles are supposed to mean something, I want them to look the part as much as I can.

So, instead of using SmartArt, I do it manually. I manually create three circles and then make them the right size. What this technique does NOT do is size the crossed parts properly but for me it’s still better than three identical circles. And, it also doesn’t account for perceptions of the size depending on the height of the circle vs the area of the circle.

Step #1: I’ve put my raw data into Excel though it is completely unnecessary. For this technique, the data table can be written solely in your brain. Using the ‘insert shape’ option, choose a circle. If you hold the ‘shift’ key down while you draw the circle, it will turn into a perfect circle.

venn diagram excel

Step #2: Copy the circle 3 times for each of the 3 circles of the Venn diagram. Now, select one of the circles and then right click. A menu will appear and you can choose the size and properties option. This option let’s you choose the exact size of the circle. First, click on the ‘Lock aspect ratio’ button. Second, in the height box, type in the number that represents the size of the circle. Don’t worry if the circle is way too big or small. Just get the number right. Repeat for each of the three circles.venn diagram excel

Step #3: Now you should have 3 circles that represent the 3 sizes in the right proportions. You can now reposition the circles so that they overlap properly. If the circles are way too big or small, then use the + or – options in the bottom right of the screen. The circles will then fit into the screen.  venn diagram excel

Step #4:  Now you can re-colour the circles or make the circle lines transparent. Just right click on the circle you want to revise and choose line and fill until you’ve got it the way you like. You can also make the rows and columns have white lines by clicking on the cross-hatched box and re-colouring them. Now you can treat the object as you might any other in Excel. Myself, I make the screen as large as possible, screen cap it, paste it into the Paint program on my machine, and then save it as a brand new jpg image. You’re done!venn diagram excel


2012 CNE Food Venn Diagram featuring the Deep Fried Bacon Wrapped Mars Bar

2012 CNE Food Venn DiagramI have to admit it.

I’m pretty proud of my CNE eating accomplishments this year. Unlike previous years where I managed to fill out all sections of the Venn diagram, this year I was able to avoid those boring and overly simplistic sections that fulfill only one requirement. This year, I focused entire on “food” that incorporated at least two of the circles.

My favourite, of course, was the magically delicious, deep fried, bacon wrapped Mars Bar. Massively gooey and chewy goodness.


Hotdog Eclair 2012 CNE

Hotdog Chocolate Eclair – One bite and it gushes all over. Yum.

Deep Fried Bacon Wrapped Mars Bar

Deep fried Bacon Wrapped Mars Bar – Deliciously gooey

Inside the Deep Fried Bacon Wrapped Mars Bar

Inside the Magically Delicious Deep Fried Bacon Wrapped Mars Bar

Deep Fried Brownie and Deep Fried Rice Krispie Square

Deep Fried Brownie and Deep Fried Rice Krispie Square – Try and guess which is which

Deep Fried Oreos

Deep Fried Oreos – Good but not extraordinary

Chicken with Waffles and Syrup

Chicken with Waffles and Syrup

Deep Fried Cheesecake

Massively Giant Deep Fried Cheesecake mmmm



Venn Diagram of Niagara Falls Attractions: Belugas, Butterflies, and Bears

There’s much to do in Niagara Falls and it all falls under a few categories. 1) Do you want to pay money? 2) Do you want to see nature? and 3) Do you want to get wet? Fortunately, cheapos can enjoy all the fun of getting wet and seeing nature up close without spending an admission dime – but we did spend a dime or two this time.

We did all of these things (plus more) in about four days and 60km of walking and it was well worth it. I pet the beluga whales at Marineland, which is great to visit midweek and pre-season when you are forced to wait impatiently in 3 second long lines. I waited for just one of thousands of butterflies to land on me at the Butterfly Conservatory. And, I risked life and limb walking around the top, middle, and bottom edges of the Niagara river. Niagara Glen is cool and the hiking trails on the US side of the river are also neat.


Venn Diagram of Deep Fried, On a Stick, Sweets I Ate

[tweetmeme source=”lovestats” only_single=false]I recently attended the CNE (Canadian National Exhibition) which is a large fair of rides, attractions, food and shopping in Toronto. I, of course, was most interested in the food and particularly that which bordered on whether it was even food to begin with. Given the unique characteristics of those items, I thought it best to share my menu in Venn diagram format.
CNE venn diagram deep fried butter muskateers twinkie

For those of you going “What the ^$%”, here are some descriptions and photos. See if you can tell which is which.

Butter: Take a cold pat of butter, put a toothpick in it, dip it in batter, deep fry. End result is a hot buttery hollow Timbit. Yum.
Twinkie: Unwrap, shove a stick, dip in batter, deep fry
3 Muskateers: Unwarp, shove a stick, dip in batter, deep fry
Mac&Cheese: Plum size balls of mac&cheese, rolled in crumbs, deep fry

%d bloggers like this: