How can we do it ?


I need to make an Excel spreadsheet that will create a Venn Diagram with anywhere from 2 to 6 circles.

For instance, if i needed a diagram with 3 circle of A, B and C. The total population is 836. A is US citizens and n=419. B is asian descent and n=171. C is college educated and n=246. A/B is n=80, Asian us citizens. B/C is n=87. A/C n=138. ABC is 53. I would enter all these numbers and a venn diagram would be produced.

Does anyone know of software or code that will do this? Please help. thank you.

I didn't like this idea
http://www.internet4classrooms.com/excel_venn.htm

I want excel to read directly the numbers , no need to add it by myself . Let's say I have 100 ball , 40 blue 50 red 10 red and blue , i need excel to draw this overlap circles ?

if I change from the data any number it will be reflected in the chart .