Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.charting




Proportional Venn Diagrams
Greetings Excel gurus,
I'm looking to create a Venn diagram that depicts not only relationships among entities but also their relative size. For example, Group A is of size 60, Group B, size 30, is a subset of A; Group C, size 20, is also a subset of A, and includes an overlap of 15 with group B. In other words, B & C are partially overlapping, and both fully included in A. I would like the circles' areas and the overlapping portion to be proportionate to their sizes. Does anybody know how this can be done? (It doesn't have to be in Excel if someone can recommend a better tool or application for this process, ideally in Office 2007 or a freely downloadable piece of software.) Thanks for any suggestions or pointers. Nevet 
#2




Answer: Proportional Venn Diagrams
Hello Nevet,
You can create a proportional Venn diagram in Excel using the SmartArt feature. Here are the steps:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.charting




Proportional Venn Diagrams
On Tue, 28 Aug 2007, in microsoft.public.excel.charting,
Nevet said: I'm looking to create a Venn diagram that depicts not only relationships among entities but also their relative size. For example, Group A is of size 60, Group B, size 30, is a subset of A; Group C, size 20, is also a subset of A, and includes an overlap of 15 with group B. In other words, B & C are partially overlapping, and both fully included in A. I would like the circles' areas and the overlapping portion to be proportionate to their sizes. Since you say B and C are entirely inside A, your problem boils down to getting just two circles to overlap. I once used trigonometry in a BASIC program, to work out where two such circles should be, although I don't have the equation to hand anymore. You can get the proportionality of the circles easily enough using a Bubble Chart type, but Excel bubble charts don't preserve the relationship between bubble radius and XY scale properly, so trigonometry wouldn't work there. If you wanted to use Excel for the calculation and graph drawing, you'd have to draw circular lines instead, using XY series. To be honest, I doubt the value to your audience of meticulouslycalculated circles would be worth the effort, especially as you have only one graph to draw. Have you considered just using a drawing program and doing it freehand, estimating the proportions by eye? Or maybe you could use the spreadsheet to create a rectangular version, setting the cells to squares and coloring them in? This would have the advantage that the readers could count the squares exactly.  Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder please send your email to del3 instead. 
#4
Posted to microsoft.public.excel.charting




Proportional Venn Diagrams
Del, Thanks for the reply. I believe you are correct & will simply use
freehand drawing for my purpose. I was hoping that Excel or some other charting program had this functionality, but if not, I can still make (or even exaggerate :) my point visually. Nevet 
#5
Posted to microsoft.public.excel.charting




Proportional Venn Diagrams
Nevet,
Since the same question has been asked on the SAS bboard recently, I presume that a number of people are starting to show interest in the presentation method. I don't have an excel solution, but did find a paper that describes how to do it, as well as a Java applet that accomplishes the task. Possibly someone on this board can translate the logic into Excel? The paper and applet can be found at: http://www.cs.uvic.ca/~ruskey/Public...a/VennArea.pdf http://www.cs.uvic.ca/~schow/DrawVenn/instructions.html HTH, Art  On Aug 28, 6:22 pm, Nevet wrote: Greetings Excel gurus, I'm looking to create a Venn diagram that depicts not only relationships among entities but also their relative size. For example, Group A is of size 60, Group B, size 30, is a subset of A; Group C, size 20, is also a subset of A, and includes an overlap of 15 with group B. In other words, B & C are partially overlapping, and both fully included in A. I would like the circles' areas and the overlapping portion to be proportionate to their sizes. Does anybody know how this can be done? (It doesn't have to be in Excel if someone can recommend a better tool or application for this process, ideally in Office 2007 or a freely downloadable piece of software.) Thanks for any suggestions or pointers. Nevet 
#6
Posted to microsoft.public.excel.charting




Proportional Venn Diagrams
Very cool! Thanks for the pointer!
"Arthur Tabachneck" wrote: I don't have an excel solution, but did find a paper that describes how to do it, as well as a Java applet that accomplishes the task. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
how do i get venn diagrams in excel sheets?  Charts and Charting in Excel  
how/can do i do a proportional circle?  Excel Discussion (Misc queries)  
Venn Diagrams  Excel Discussion (Misc queries)  
Proportional x and y axi  Charts and Charting in Excel  
Proportional sizing of scrollbox thumb  Excel Discussion (Misc queries) 