Venn Diagram - Autosizing of circles? Macro or add-in?

[davejago]

I'm building a Venn Diagram to show revenue across 3 Lines of Business within our organization. The overlap sections will show cross-selling between the lines of business.

I would like to SCALE the diagram, ideally automatically, so that the circles are representative of their revenue size, and the overlaps are also in proportion.

Does anyone know of a macro, add-in, or piece of (cheap) software that could do this for me?

Thanks in advance.

 

[westconn1]

so you want 3 circles overlapping a bit
can you post a sample data, with rough image?

 

[Andrew Poulsom]

Look here:

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