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.
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