Need to create Venn diagram based on table

Not even sure if this is possible.

As shown on the attached. grid shows how many clients each salesperson deals with, and how many sales people each client deals with.

End User wants to show those relationships visually in Venn diagrams, as in the four "examples" on the attachment, but no idea how to "code" it, or even if is possible?

Employee Venn:
1. Select employee from Drop List
2. Code counts how many columns say "Yes" for that person, and creates a circle for each one.
3. Identifies which clients they are, and labels the circles with the relevant details - ideally would have different colours for different clients.
4. Put circles into relevant layout for the total of circles involved.

Client Venn
1. Select Client from Drop List
2. Code counts how many rows say "Yes" for that client, and creates a circle for each one.
3. Identifies which employees they are, and labels the circles with the relevant details
4. Puts the circles into the relevant layout for the total of circles involved.

Code would also have to accommodate "dynamic" ranges, as client and employee totals and details will change over time.

Any suggestions or pointers valued as ever.

Ochimus

since yours isnt a weighted veen chart...eg all circles are the same size

you could use the smartArt charts?
assuming 7 is your max...the charts lose too much detail after 7

For some reason i cant get smartArts to change colorthemes or styles properly

the basic premise works though
see attached file

Please Login or Register  to view this content.

what you have suggested it no longer a Veen diagram
Veen is meant to overlap each other showing coorelative points

in your example is now hexagon cluster

which you can be replaced with basic radial chart - which you can also do with smart art
layout

83>> Basic Radial
it will require some tweaking of the VBA code as the employee is the parent and every client is then child of the parent

if i have time later today i give it a try to amend
its just a matter of getting the syntax

Please Login or Register  to view this content.

code to do SmartArt with basic radial instead
also i found out how to do the color theme and quick style properly

use this below code to figure out what is what, comment out each

Please Login or Register  to view this content.