Forum Discussion
Venn diagram or names in a list
Hi I would like to make a venn diagram using three circles to show the overlap between three lists of names. I dont want to use the art version of it, I want it to populate from data. I have attac...
Hi again
Sorry to be a pain but between reading your replies and reading up and what you posted I have cobbled together a formula which works well for the three columns, the formula is in cell M2 on the sheet I have attached, but I cant work out how to use the same formula for just two columns, im sure it should be easier than the three columns one but i cant get it to work! Do you have any ideas?
Thank you for all your help so far.
Ian
Thank you Sergei and IAN for this post.Can you please explain the same by using venn diagram in the excel and show how they both data and venn diagram interact dynamically.i mean when values in excel data changes then values in venn diagram should change.Is this possible.