Hi Mark, Excel does not have a built-in ability to produce venn diagram charts. Although if I am not wrong!! Excel-XP had a venn diagram autoshape. I am not sure that it is linked to data in anyway though.
I also read somewhere that: Excel 2k3 can create a Venn diagram using the menu Insert > Diagram then selecting Venn. You can then add more objects to increase the complexity. You can then navigate to the cells underneath the diagram to add formulas or links but thats as good as it gets. It is pretty handy. However, there are several links on the internet, explaining, how to achieve the same with Excel. I have compiled a set of links below for you. hope these help. http://www.andypope.info/ngs/ng9.htm I personally liked the next three links: http://www.data-miners.com/blog/2008/10/creating-accurate-venn-diagrams-in.html http://www.data-miners.com/blog/2008/11/creating-accurate-venn-diagrams-in.html http://www.data-miners.com/blog/venn-20081025.xls http://www.mrexcel.com/tip090.shtml http://office.microsoft.com/en-us/excel/HA103364221033.aspx http://office.microsoft.com/en-us/templates/TC300015891033.aspx?ofcresset=1 http://www.youtube.com/watch?v=im27mda7pnw http://www.internet4classrooms.com/excel_venn.htm http://www.internet4classrooms.com/venn_diagram_07.htm http://www.cs.kent.ac.uk/people/staff/pjr/EulerVennCircles/EulerVennApplet.html All the above will help u with a lot of ideas regarding the venn. Hope it Helps. Regards, Andy On Sat, Feb 7, 2009 at 8:49 PM, Mark Hanley <goo...@markhanley.co.uk> wrote: > > I need to create a Venn diagram with three circles and insert names > into each section based on three sets of values. I'm wondering if the > drawing API in VBA would be up to the job. I need to be able to > position the names with x and y coordinates so that they are in the > right section (i.e. I don't want to just plop them in a cell which is > close to the region you want the name to be in). The diagram should be > printable. > > I want to use excel for portability and simplicity. > > I'd really appreciate any thoughts you may have on whether this sounds > feasible and, if so, how you would approach it. > > Best regards > > Mark > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
