skip to Main Content

Treemap Chart Maker

4.67 (9 reviews)

Treemap Chart Maker to visualize hierarchical data and display the data distribution within the hierarchy. Flexible, simple, and multi-optional chart maker in Excel!

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

A Treemap chart is a simple tool for visualizing layered data in the form of rectangles. This tree diagram maker shows how data is spread across multiple segments and subsegments in Excel.

Treemap-Chart-Maker-Someka-Excel-S03_3

Each item is represented by a rectangular shape, while each sub-branch is displayed by a smaller one. So larger rectangles with different colors show the top categories in the data set.

Treemap Chart Maker Features

Treemap generator allows you to display your hierarchical data with a clear visualization. It has two main input options: 1) Basic, 2) Advanced. Each of these generates two visual outputs, which are “treemap” and “hierarchy tree”.

Both sections will let you input up to 500 different items. Also, you can easily navigate between these sections just by clicking the related button.

Treemap-Chart-Maker-Someka-Excel-S02

1) Basic Treemap Input

This basic option is suitable when your data does not contain many layers of sub-categories. It consists of a list of items, as well as a chart preview. This section allows only for 2 layers of input categories.

2) Advanced Treemap Input

This option gives you the opportunity to create a treemap with multiple levels. It has additional 4 columns, where you can have your data split into many levels of sub-categories.

Treemap-Chart-Maker-Someka-Excel-S06

This section has 5 sub-category options, but you can ignore some of them while creating your treemap. So you don’t need to remove data if you just want to see the output without a specific column. Just ignore it from the dropdown menu on the top menu.

Treemap-Chart-Maker-Someka-Excel-S07

Furthermore, there are Hide or Show options for the total values, where you can select whether to show the values or just hide them.

Visual Outputs

You will have a chart sheet and hierarchy tree output for each of the basic and advanced treemap options.

  • Chart Sheet

This section will display your treemap chart. You can customize the treemap diagram with different colors or styles. After selecting the chart, just go to the chart design tab to make any change you want. Besides changing the visual design, you can also change the title, or resize the chart.

Treemap-Chart-Maker-Someka-Excel-S01

  • Hierarchy Tree

This section displays your data in tree form. This tree is the link between the input data and the treemap chart. You can see here all your categories and sub-categories sorted and grouped way.

Treemap-Chart-Maker-Someka-Excel-S08

Note: All sheets have a dynamic print area so no matter how much data you have, the print area will be set according to it. However, if you resize the charts, you can print the whole chart by selecting the chart.

Treemap Chart Maker Features Summary:

  • Visualize Hierarchical Data
  • Display data distribution within the hierarchy
  • Fully customizable and ready to print
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Treemap Chart Maker is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

9 reviews for Treemap Chart Maker

  1. Dorine

    useful app!

  2. Robertina

    you preapered this product in a detailed way thank you team.

  3. Glen

    How can I print chart_????

    • Someka

      Hello Glen,

      To print the chart, select it first and then go to “File → Print”
      Hope this helps!

  4. Anne B

    for advances tree map how can I remove some subcategories

    • Someka

      Hello Anne,

      To hide a specific column with data, choose from the dropdown list above each header “Ignore”, so data in a specific column will be omitted.

      Please see the image below:
      Treemap-Chart-Maker-Someka-Excel-S07

  5. Louise S

    thank you for two options for chart and hieraryc tree but I want to change chart colors

    • Someka

      Hello Louise,

      After you select the chart you can select “Chart Design” in the ribbon and update the style, colors, or change the chart layout.

      Hope this helps!

  6. Gonzalo

    GREAT!

  7. Roman A

    Can I somehow export the prepared chart? I want to use it in my presentation.

    • Someka

      Hello Roman,

      Because this template is VBA free we didn’t add a button that would do it with one click but you can simply do it by yourself.
      When you select a chart. Just click the right mouse button and select Save as Picture.
      Please see the image below:

      treemap_saveas

  8. Blanch

    Nice template, thanks! those excel treemaps always made me confused.

  9. Charles P

    finally i found the excel i was looking for but i just have a question how can I add more rows?

    • Someka

      Hello Charles,

      In the modifiable version, you have 500 rows available just click the “+” sign on the left side of the template and you can fill it all out 🙂
      Please see the image below:

      treemap_adding-rows

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED EXCEL TEMPLATES