Free Excel Tree Chart Template: Options and Setup

Charts & pivot tables · Updated November 20, 2026

Yes. You can make a tree chart in Microsoft Excel for Microsoft 365 without paying for a separate template: use Insert > SmartArt > Hierarchy for a branch-style diagram, or Insert > Insert Hierarchy Chart > Treemap for a chart that compares nested categories by size. If you want a ready-made workbook, free downloads may also be available from Microsoft Create and other providers, but check what kind of tree chart the file contains before using it.

What people mean by a tree chart

“Tree chart” can refer to several visuals, and choosing the right one is the first step. A hierarchy diagram shows relationships from a parent item to its children, usually through connecting lines. It is useful for an organization chart, a family relationship diagram, a product category map, or a project breakdown. A treemap is a chart made of nested rectangles; rectangle area represents a value, such as sales or budget. It is better for comparing the relative size of categories than for displaying every connection as a branch.

People also use “tree chart” to mean a decision tree, where branches represent choices and possible outcomes. Excel does not turn a data table into a complete decision tree automatically. For a small decision process, SmartArt or manually arranged shapes and connectors can work; for a large or frequently changing tree, a dedicated diagramming tool may be easier to maintain.

Before downloading a template, decide what you need readers to understand. If they must trace who reports to whom, use a hierarchy diagram. If they need to compare category totals, use a treemap. A visually attractive file built for the wrong purpose can be more confusing than a simple blank workbook.

Free options built into Excel

Excel’s built-in features are often the simplest free starting point if you already have access to the application. SmartArt provides editable hierarchy layouts, while the Treemap chart uses worksheet data to create nested blocks. You do not need a third-party file for either option, although you may choose to save your finished work as a reusable template.

  • SmartArt hierarchy: A shape-based diagram for showing named items and their parent-child connections. It is convenient for a small or moderate tree where the layout matters more than calculating category size.
  • Treemap chart: A data-driven chart for showing a hierarchy alongside numeric values. Its areas help readers compare quantities, but it is not designed to show branch connectors like an organization chart.
  • Shapes and connectors: A manual approach for a custom decision tree or unusual layout. It offers more control, but updating many branches can take time.

These features are included in Excel, not a promise that Excel itself is free. Whether you can use them depends on your Microsoft 365 or Office access. Excel for the web and other editions may have different feature availability or editing controls. The steps below describe Excel for Microsoft 365 on Windows; on Mac, the Insert tab also provides SmartArt and chart options, though the ribbon arrangement can differ.

Make a hierarchy tree with SmartArt

For a basic organization or category tree, start with a blank worksheet and use Insert > SmartArt > Hierarchy. Choose a layout that fits the number of levels, then select OK. The Text Pane lets you enter the labels and organize them as a hierarchy. In many SmartArt layouts, pressing Enter creates another item and using Tab or Shift+Tab changes an item’s level; check the on-screen structure as you work so a child is not accidentally made a peer of its parent.

  1. Write down the root item and the levels beneath it before arranging the diagram. For example: Company, Operations, Customer Support, and Support Team A.
  2. Insert a hierarchy layout and enter each label in the Text Pane. Indent child items beneath their parent items.
  3. Use SmartArt Design to choose a layout or style and use the Format tab to adjust selected shapes. Keep colors and fonts consistent.
  4. Resize the diagram and review it at normal viewing size. If labels become cramped, shorten them or choose a less dense layout.

SmartArt is convenient when the tree is mainly a communication graphic. It is not a database: a large hierarchy can become difficult to edit, and the shapes do not automatically update from a separate, well-structured list in the way a chart is linked to worksheet values. Keep a source list in the workbook if the names or reporting relationships change often.

Build a treemap from worksheet data

A Treemap chart needs category levels and a numeric measure. Arrange the worksheet with one column for each level and a final column for the value. For example, a retail workbook might have Department, Category, and Sales columns. Rows could contain Home, Kitchen, Cookware, 12000 and Home, Bedding, Sheets, 8000. The repeated department name tells Excel that the categories belong within the same top-level group, while the sales figures determine the relative areas.

Enter the headings and rows in a continuous rectangular range, select that data, then choose Insert > Insert Hierarchy Chart > Treemap. Excel creates the chart, which you can resize and format with the Chart Design and Format tabs. A treemap works best when the values are meaningful, nonnegative quantities and the hierarchy has a sensible number of levels. If the table has many tiny categories, labels may not fit inside the rectangles.

Unlike a hierarchy diagram, a treemap does not show a line connecting each child to its parent. The nesting and labels convey the grouping. It also does not make a zero or negative value visually comparable in the same way as positive area. If a category has no meaningful numeric measure, use SmartArt or another diagram instead of inventing values just to make a treemap.

Find and evaluate a downloadable template

For a downloadable workbook, search Microsoft Create or a reputable template provider for terms such as “organization chart,” “hierarchy chart,” or “treemap.” Search by the specific purpose, because a file labeled “tree chart” may be a family tree, a reporting diagram, a decision tree, or a treemap. Template catalogs and availability change, so confirm the current file details on the provider’s page rather than assuming a particular design is still offered.

  • Check that the file is an Excel workbook and that the preview matches the structure you need.
  • Look for an explanation of how to add items, levels, or source data. A static image pasted into a sheet is not an editable tree.
  • Check whether the workbook relies on macros or external data connections. If those are not needed, choose a macro-free workbook where possible.
  • Review the layout with your own sample data before entering sensitive or business-critical information.

A template can save setup time, but it does not guarantee that the chart will remain easy to update. Some files use manually positioned shapes; others contain a chart linked to a data table. Those designs behave differently when you add a new branch or rename a category, so try a small edit first.

How to choose the right layout

Choose based on the question the chart should answer, not just the appearance of a sample. A reporting tree answers “Who belongs under whom?” A treemap answers “Which categories account for the most or least of this total?” A decision tree answers “What paths and outcomes follow from these choices?” One workbook can include more than one view, but each should have a clear purpose.

  • Use SmartArt for a straightforward hierarchy with labels and visible branches.
  • Use a treemap when you have nested categories and comparable quantities, such as revenue by department and product group.
  • Use shapes and connectors for a small custom decision process with conditions or outcomes that do not fit a standard hierarchy layout.
  • Use a specialist diagramming tool when the tree is very large, needs frequent collaborative editing, or requires complex connectors and automatic layout.

Think about the audience and the final format, too. A tree that is readable on a desktop may be too dense on a printed page or phone screen. Include a useful title, keep labels concise, and explain units for a treemap—for example, “Sales, in thousands of dollars.” Avoid relying on color alone to communicate important distinctions.

Common problems and practical fixes

One frequent issue is choosing a treemap when the reader expects a branch diagram. Treemap rectangles show nesting, but not explicit connector lines. The reverse mistake is using SmartArt to compare numeric totals: readers may see the structure but cannot readily compare the magnitude of categories. Match the chart type to the message before spending time on formatting.

If Excel’s treemap looks empty or unclear, check that the selected range includes the header row, that category columns are filled consistently, and that the final measure column contains numbers rather than text. Remove blank rows inside the source range. If the labels overlap or disappear, reduce the number of categories, shorten long names, or show fewer hierarchy levels. A treemap has limited space for text in small rectangles.

For SmartArt, a crowded chart usually means there are too many nodes for the chosen layout or labels are too long. Split a very large tree into related views, or show only the level of detail the audience needs. Be careful when dragging shapes manually: a connector or box can shift out of alignment, and the diagram may be hard to maintain. Keep an untouched copy of the source workbook when making substantial edits.

Saving a reusable version and sharing it

Once the chart is correct, save a working copy as an Excel workbook. To make a reusable starting point, remove example names or values, leave clear instructions, and save a separate template file using File > Save As and the Excel Template file type if it is available in your edition. Keep a normal workbook copy as well, since a template is intended to create new files rather than serve as the only record of completed work.

Before sharing, check that the chart and its labels remain readable after printing or exporting to PDF. For a data-driven treemap, make sure the source values are included and that a recipient can tell what they represent. For SmartArt, make sure the editable diagram is still in the workbook rather than only an exported picture. If the file came from outside your organization, follow your usual security process and do not enable macros just to view a chart.

Frequently Asked Questions

Does Excel have a free tree chart template?
Excel includes SmartArt hierarchy layouts and a Treemap chart, so you can build either without downloading a template. Downloadable templates may also be available from Microsoft Create or other providers; verify the file type and chart structure before use.

Is a treemap the same as a tree diagram?
No. A treemap uses nested rectangles whose area represents values. A tree diagram uses nodes and branches to show relationships or paths. Use a hierarchy diagram when visible parent-child connections matter.

Can I make an organization chart in Excel?
Yes. In Excel for Microsoft 365 on Windows, choose Insert > SmartArt > Hierarchy and enter roles or names in the Text Pane. For a large or frequently changing organization, keep a separate source list and consider whether a dedicated org-chart tool will be easier to maintain.

Can I make a decision tree with Excel?
Yes, for a small one, using SmartArt or worksheet shapes and connectors. Excel does not automatically generate a full decision tree from a list of choices, so complex trees may be easier to build in dedicated diagramming software.

Why are some treemap labels missing?
Small rectangles may not have enough room for labels, especially when the chart contains many categories or long names. Simplify the hierarchy, shorten labels, or enlarge the chart; some labels may remain hidden when there is not enough space.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.