Intersection of sets, calculations and graphics

[Visor]

Forum Dear friends, my question now is regarding if Excel can be done intersection of sets, both calculations as the graph.

You could provide me an example?

Thank you for your kind answers

 

[Chihiro]

Are you looking for something like what's discussed in the link?
http://chandoo.org/forum/threads/intersection-points.27822/#post-166499

It is possible, but will require bit of calculation steps.

 

[Visor]

It is right for the calculations, but ... the graph can do in Venn diagram (closed figure ??), as the example file here?

 

[Chihiro]

I didn't think it possible. But some search resulted in link below.
http://blog.data-miners.com/2008/11/creating-accurate-venn-diagrams-in.html

This may also interest you (web based Venn Diagram generator).
http://www.cmbi.ru.nl/cdd/biovenn/

 

[Visor]

very interesting!!!

but, Perhaps there is the option to use freeform and if we have solved calculus, then we can copy the result and placed within the corresponding figure; this,.. using macros
what do you think?

 

[Chihiro]

I think it is possible. Though I've never worked with freeform via VBA.

 

[Visor]

Here is an example of an issue is not solved yet.
You click to the height of the cell 14 (green cell) in each button, and choose the shape of the figure.

This could give you ideas to solve that issue both raised as this

http://forum.chandoo.org/threads/growing-a-freeform-line-vector-image.26528/#post-159658

 

[Chihiro]

Whoa, quite a bit to digest.

 

[Visor]

Ok, I hope you can help me