Venn Diagrams?

mojo · Mar 19th, 2002, 09:15 AM

Can you make Venn Diagrams in Excel 2000? I'm trying to show accurate figures of shared data between two fields of data.

Damon Ostrander · Mar 19th, 2002, 01:56 PM

Hi mojo,

As you are probably aware, there is no built-in Venn diagram capability. However, with a bit if VBA code and the appropriate algorithms it is quite easy to overlap circles (or other Shape objects) to produce the exact amount of area overlap you want, and to shade them in such a way that, for example, the intersecting area displays in a different color than the color of either circle. Is this what you want?

Keep Excelling.

Damon

Mar 19th, 2002, 01:56 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi mojo, As you are probably aware, there is no built-in Venn diagram capability. However, with a bit if VBA code and the appropriate algorithms it is quite easy to overlap circles (or other Shape objects) to produce the exact amount of area overlap you want, and to shade them in such a way that, for example, the intersecting area displays in a different color than the color of either circle. Is this what you want? Keep Excelling. Damon __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 09:15 AM	#1
mojo New Member Join Date: Mar 2002 Posts: 1	Can you make Venn Diagrams in Excel 2000? I'm trying to show accurate figures of shared data between two fields of data.