Originally Posted by

**justinbentley1** Hi,

First off, apologies if this is the wrong forum or even the wrong site...

This is a geometry question - but I haven't a clue..

What I'm trying to do is use MS Excel (2003) visual basic to display a 2 circle Venn diagram based on certain facts.

Facts are:

Population 1 (Area of circle 1)

Population 2 (Area of circle 2)

Intersect (n of Population 2 also in Population 1)

I'm struggling with calculating the distance between the center of each circle based on the Intersect.

Eg.

Pop 1 = 100

Pop 2 = 200

Intersect = 50

Many thanks for any assistance