Relationship Diagram in Excel or other Microsoft Tools

Visitor

Hello Experts,

 

I am trying to create a complex relationship diagram in Excel or any other Microsoft Tool available.

 

A short and simple version of data is below:

Heading 

Money Link In 

Money Link Out

Wire In

Wire Out

Savings Account

Yes

No

Yes

Yes

Checking Account

No

Yes

Yes

No

Individual

Yes

No

Yes

Yes

 

I want three boxes for Heading Column.

 

And Money out arrows from "Checking Account" (as its "Yes" in Money Link Out) towards "Savings Account" and "Individual" (as its "Yes" in Money Link In)

 

Likewise Wire out arrows from "Savings Account" and "Individual" Account towards other two Account Types (as all three has "Yes" in Wire In.

 

2021-10-15_11-15-16.jpg

 

The blue arrow is for Money Link. The yellow arrow is for Wire.

 

There can be more Accounts/boxes. There can be more relationship types (apart from Money Link and Wire). And I want it to be dynamic such that if we change Yes/No in the base data, it reflects in diagram automatically.

 

Hope there is some solution which I can make dynamic by choosing Yes/No from Data Validation Dropdowns and the effect is given in the diagram/chart in the tool.

 

Anticipating some solutions.

 

Thanks and Regards,

Dhaval

0 Replies