Venn Diagrams (v2)

[barry(uk)]

I'll rephrase this:
How do I get the circles and their overlaps in a venn diagram to be representive of data in a range?

 

[PaddyD]

in no way consider this a recommendation, but:

http://www.smartdraw.com/

a) does Venn diagrams
b) is available free for a 30 day trial
c) is a windows based drawing / charting tool that interacts with excel

paddy

 

[barry(uk)]

Damon & Paddy D
Thanks for your interest in this problem. After some consideration I came to realise that it is impossible to visually display (in terms of area) relationships between more than two sets(circles) in a venn diagram. If you can prove me wrong in this I would be very impressed! I got round the problem using shapes to create 4 eclipsing ovals (a job in itself!) which in terms of area did not represent the extent of the relationship, but with text boxes I was able to show the relationship between sets in percentages.

From a very cold London Town, Barry