Is there any way to do SET(Number of set, Intersection, Union) operations from excel sheet?

Al Muhaimin 0
Viewed 25

I have the following excel sheet with Different Phenotypes as header.

enter image description here

But I need to find out a way to draw venn diagram out of it. For that I need to find out the values like n(1 intersect 2), n(1 intersect 3) ..... so on. Is there any automated or efficient way to do this?

venn-diagram excel
1 Answers

Didnt help the whole way. But had some good references to get the job done.

  1. Set function on excel (Link)
  2. Multi set venn diagram(Upto 10 sets). Though it is time consuming and you need to enter manually, but it gets the job done. (Link)

My output diagram looks just like : Venn diagram from the table in the question

Al Muhaimin0
Related