Decision Trees In Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1676174%22%20slang%3D%22en-US%22%3EDecision%20Trees%20In%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676174%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20interested%20to%20learn%20about%20any%20sophisticated%20decision%20trees%20done%20in%20Excel.%26nbsp%3B%20I%20do%20management%20and%20decision%20sciences%20professionally%20and%20have%20produced%20decision%20trees%20for%20many%20applications%20but%20have%20typically%20used%203rd%20party%20software%20purpose%20built%20for%20these%20applications.%26nbsp%3B%20I'm%20wondering%20what%20Excel%20only%20decision%20trees%20have%20been%20built%20that%20have%20eloquent%20navigational%20features%20i.e.%20collapse%20and%20expand%20easily%20and%20cleanly.%26nbsp%3B%20I%20am%20just%20not%20too%20familiar%20with%20using%20the%20Excel%20shapes%20or%20smart%20art%20for%20dynamic%20and%20collapsible%20trees.%26nbsp%3B%20I've%20tried%20both%20smart%20art%20horizontal%20hierarchy%20(fine%20for%20simple%20trees%20that%20are%20not%20too%20big%20or%20scalable)%20and%20also%20built%20trees%20using%20shapes%20for%20for%20nodes%20and%20branches%20but%20haven't%20had%20great%20luck%20at%20producing%20clean%2C%20dynamic%2C%20scalable%20trees%20(my%20lack%20of%20skill%2Fknowledge%20with%20shapes%20for%20sophisticated%2Feloquent%20trees).%26nbsp%3B%20Thanks%20for%20any%20insights.%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1676174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1676702%22%20slang%3D%22en-US%22%3ERe%3A%20Decision%20Trees%20In%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1676702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F796567%22%20target%3D%22_blank%22%3E%40ExecStrategies%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20Excel%20to%20evaluate%20decision%20trees%2C%20but%20I%20did%20not%20focus%20on%20the%20graphical%20representation%20rather%20I%20focused%20on%20the%20probabilities%20and%20how%20to%20reach%20the%20best%20decision.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20it%20can%20be%20done%2C%20but%20I%20do%20not%20think%20it%20is%20worth%20investing%20too%20much%20time%20in%20making%20it%20dynamic%20and%2For%20automatic.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I am interested to learn about any sophisticated decision trees done in Excel.  I do management and decision sciences professionally and have produced decision trees for many applications but have typically used 3rd party software purpose built for these applications.  I'm wondering what Excel only decision trees have been built that have eloquent navigational features i.e. collapse and expand easily and cleanly.  I am just not too familiar with using the Excel shapes or smart art for dynamic and collapsible trees.  I've tried both smart art horizontal hierarchy (fine for simple trees that are not too big or scalable) and also built trees using shapes for for nodes and branches but haven't had great luck at producing clean, dynamic, scalable trees (my lack of skill/knowledge with shapes for sophisticated/eloquent trees).  Thanks for any insights.  

2 Replies
Highlighted

@ExecStrategies 

 

I have used Excel to evaluate decision trees, but I did not focus on the graphical representation rather I focused on the probabilities and how to reach the best decision. 

 

I think it can be done, but I do not think it is worth investing too much time in making it dynamic and/or automatic.

Highlighted

@Ramiz_Assaf  thanks for your response.