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