Dear All, I am working on Excel to make a decision tool. In this task I will have to construct a decision tree (Fault Tree) diagram. First of all A box will be inserted in which the text can be edited, then an AND gate shape or OR Gate shape will be added below it, then one, two or more branches will appear from the bottom of AND gate or OR Gate, more objects like triangle, box or circle will be attached to these branches. https://www.google.com/imgres?imgurl=https://www.smartdraw.com/fault-tree/img/fault-tree-3.jpg?bn%3D1510011130&imgrefurl=https://www.smartdraw.com/fault-tree/&h=482&w=526&tbnid=h2ah5PgeajS1qM:&q=fault+tree+diagram&tbnh=184&tbnw=200&usg=__fTJn_1GYYsnBFRjX_OWxfIW9oik%3D&vet=10ahUKEwjttO25oLzbAhUJLFAKHeaaAE4Q_B0IrAEwEg..i&docid=MIpK7r9PcJK0uM&itg=1&sa=X&ved=0ahUKEwjttO25oLzbAhUJLFAKHeaaAE4Q_B0IrAEwEg can anyone please tell me, how to control this thing by commands, cell formulas, form controls, active X-controls or some Macros? Regards, Farid

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to make Fault Tree diagram in Excel using commands?

Thread starter ghfareed
Start date Jun 5, 2018
Tags

box branches fault gate tree

ghfareed

New Member

Jun 5, 2018

Dear All,

I am working on Excel to make a decision tool. In this task I will have to construct a decision tree (Fault Tree) diagram.
First of all A box will be inserted in which the text can be edited, then an AND gate shape or OR Gate shape will be added below it, then one, two or more branches will appear from the bottom of AND gate or OR Gate, more objects like triangle, box or circle will be attached to these branches.

https://www.google.com/imgres?imgur...d=0ahUKEwjttO25oLzbAhUJLFAKHeaaAE4Q_B0IrAEwEg

can anyone please tell me, how to control this thing by commands, cell formulas, form controls, active X-controls or some Macros?

Regards,
Farid