Coding for Bowtie 's

Hi There, is there anyone out there that perhaps has some exposure to coding for a bowtie risk analysis diagram . I have one but mine is linked to cells as indicated on the picture below - the problem is it does not link with lines (as would be generally done in a bowtie) as per picture two.

Bowtie Diagram.JPG

Bowtie Diagram 2.JPG

You will also note that escalation on the second picture for additional events on either side of the center TOP EVENT is added with a + or a - symbol

Any ideas out there . Must note many people do this trough a software package written for it specifically but it is definitely doable in excel VBA

Is it that you want diagram 1 to be rearranged to look like diagram 2? Upload your file and I'm sure one of us can get it done, with lines too.

Here is the file

file attached

The file is locked. Need the code to make changes

Sorry I Did remove the protection but its FB

Hi, were you able to open the file coding

Yes, I was able to open the file. Once I started working on an approach, I realized it will take an immense effort to complete your request, although I haven't given up yet, it will take a lot of time.

Ok all good happy that you downloaded the file. Well let me know if it is doable for you or if not just let me know . thanks

Hallo maniacb, I was following up to find out if you have been able to look at the file with coding I had attached , is there a way to to do this

Hi there , is there perhaps anyone that has some ideas on how I can do this and expand on the existing code I have posted

Chris1976, do you still have this file? Perhaps I can try to improve it, as I am trying to make a bowtie in Excel myself.