Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

How to create a Tree Map chart in Excel 2016

By admin on October 14, 2016April 19, 2019

The Tree Map chart is a new chart type available in Microsoft® Excel® 2016. It’s used to proportionally display hierarchical levels of data in the form of different sized rectangle blocks. A sales manager can use the Tree Map chart to monitor the performance of the sales consultants.
This chart would be best suited to data that is based on categories of some kind. In this tip, we explain how to create a Tree Map chart from Item categories sold by sales consultants. Tree Map charts can only be created off of a data table, and not PivotTables.
You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2016.
1.Select the data table.
2. Select the Insert tab, then the Tree Map chart icon.

3. Click on the Tree Map chart type.

Your Tree Map chart will be automatically created. You will notice that each block represents a different colour for each item category, and a different size for each sales consultant. The size of the block is determined by the sales amount.

You can format your data labels by right clicking on them, and then selecting the “Format Data Labels” option.

Click on the value checkbox and you will notice that the sales values now appear next to the sales consultant.

By creating a Tree Map chart, the performance of the sales consultants can be easily monitored. As a result, time will be saved, leading to increased productivity.
The post How to create a Tree Map chart in Excel 2016 appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Enable the recipients of your distributed reports to interact with PivotTables like you do
How to use a slicer instead of a drop-down list in Excel

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com