• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Make a Decision Tree in Excel

How to Make a Decision Tree in Excel

By: Stephanie Ellen
  • Share
  • Share on Facebook

A decision tree can help you make decisions, whether they are day-to-day decisions or ones that have long-term effects. Decision trees can have many branches (each representing a decision), enabling you to analyze the effects of complex decisions and see the results of those decisions in a spreadsheet format. Microsoft Excel's shape tool can start off your brainstorming and allow you to create branches as you think about your decision.

Businesswoman typing on computer
credit: BananaStock/BananaStock/Getty Images

Step

Draw a square in a blank Excel worksheet. In Excel 2007, click "Insert," then "Shapes" and then click on a square. In Excel 2003, click on the "Rectangle" autoshape button on the drawing toolbar and drag the square to your worksheet.

Step

Right-click on the square and click "Add text." Type the major decision into the box. For example, you might be deciding whether to save or spend a recent windfall, so write "Save or Spend" in the box.

Video of the Day

Step

Select a "Line" shape from the toolbar. Click on the right edge of the square and drag the line to a length of an inch or two (you can change the lengths of the lines at a later time by clicking and dragging on them). In the above example, you would draw two lines of equal length (one for "Spend" and one for "Save").

Step

Draw two more squares at the end of the lines, repeating the process for inserting a square from Steps 1 and 2 to draw the square and insert text. In the given example, write "Spend" in one text box and "Save" in the other. This creates your first set of branches.

Step

Repeat the above process to as many branches as you need to your tree.

Show Comments

Related Articles

How to Use Excel to Calculate How Much a Loan Will Cost

How to Use Excel to Calculate How Much a Loan Will Cost

Around The Home
Productivity
By: Mark Kennan
How to Insert Minor & Major Grid Lines in Excel

How to Insert Minor & Major Grid Lines in Excel

Around The Home
Productivity
By: C. Taylor
How to Get Annual Sales in Excel

How to Get Annual Sales in Excel

Around The Home
Productivity
By: Shea Laverty
How to Use MS Excel to Make Trackers

How to Use MS Excel to Make Trackers

Around The Home
Productivity
By: Filonia LeChat
How to Do a Break Even Chart in Excel

How to Do a Break Even Chart in Excel

Around The Home
Productivity
By: Ron Price
How to Compare Two Excel Spreadsheets

How to Compare Two Excel Spreadsheets

Around The Home
Productivity
By: Edward Mercer
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.