question

DhavalPaun-2225 avatar image
0 Votes"
DhavalPaun-2225 asked

Relationship Diagram with Excel VBA

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:

141034-2021-10-15-13-00-42.jpg



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.

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


office-vba-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers