I have a list of 17 firms who are in 8 possible states. I need to see/show where there is the highest (next highest, etc) concentration of overlap amongst the firms. I'm thinking a Venn diagram would be perfect, but I can't figure out how to put it into an Excel Graph. I'm looking for something that's accurate and automated not a manual approximation.

Can anyone help me?

Here's the file: VennData.xlsx

Thanks in advance!
ARH3