How to Make a Decision Tree in Excel | Lucidchart Blog
Skip to main content

Imagine that you’re sitting in a meeting with your company’s executives. You have decided that it will be more profitable for the company to build out a new software feature than to leverage an existing one—you have the data to prove it—but now you have to convince your leaders. And your spreadsheet of numbers projected on the screen is putting them to sleep.

Transform your data into a more interesting, more convincing decision tree diagram in Excel. Decision trees provide a more consumable layout for your data as you consider different options, and then they help justify your decision to others. Learn how to make a decision tree in Excel, using Lucidchart and its Microsoft Office add-in to make the process faster.

Why use Lucidchart?

Speaking of decisions, let’s talk about why Lucidchart is your best choice for building an Excel tree diagram:

  • It’s intuitive. Don’t get us wrong—decision making is an important process. But wouldn’t you rather spend less time building a decision tree and more time executing the plan you decide on? Drag shapes onto the canvas, instantly connect them with lines, and add your text. We keep things simple.
  • It’s professional. In Lucidchart, you can line up your shapes more easily and change styling like colors and fonts for a more personalized, dignified look.
  • It’s easy to import. Because Lucidchart integrates with Microsoft Office, you are only a few clicks away from transporting your decision tree to your Excel spreadsheet.

If you don’t have a Lucidchart account yet, we’ll hook you up. Sign up for free below.

Okay, you’ve convinced me… how do I use it?

Now that you have signed up for Lucidchart, learn how to create a decision tree in Excel using our tool.

1. Make your decision tree diagram in Lucidchart.

Start with a blank document or use this decision tree template for Excel:

decision tree template Excel

Squares symbolize decisions, circles symbolize uncertain outcomes, and triangles symbolize final outcomes. Depending on your situation, you can add as much data and as many branches as you need. For step-by-step instructions, see our full tutorial on how to make a decision tree diagram.

2. Install the Microsoft Excel add-in.

You can set up this integration in three steps: click Insert > Apps for Office, find Lucidchart in the App Store, and click “Add.” We’ll even cut out a step—just click the button below to get started.

3. Import your diagram.

The add-in puts your Lucidchart diagrams right in Excel! Select the decision tree diagram you would like, and click “Insert” to embed the decision tree right away or click “Edit” to go back to the Lucidchart editor.

A better diagramming experience. An easy import. That’s Lucidchart with Microsoft Excel.

What advice do you have regarding how to draw a decision tree in Excel? We’d love to hear in the comments.