Make Treemap Chart in Excel 2016

Create a Treemap chart in Excel 2016
A Treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers.
The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle.
The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.
Treemap charts are good for comparing proportions within the hierarchy, however, treemap charts aren't great at showing hierarchical levels between the largest categories and each data point. A sunburst chart is a much better visual chart for showing that.
Excel 2016's new Treemap chart offers an interesting way to visualize a hierarchy of data. With it, you can compare data for different categories at a glance, such as revenue for a bookstore by book genre and sub-genres or laptop sales by manufacturer and model. Here's how to create a Treemap in just a couple of clicks
How to make Treemap graph in Excel 2016
Open your spreadsheet, select the target data, and click Insert - Insert Hierarchy Chart -Treemap. The chart drops in and opens the Chart Tools/Design Ribbon menus. Scroll across the Design options and select one that fits your project.
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 9752003788 10 Most Used Formulas MS Excel
• 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners || Part 1
• Learn Basic Excel Skil...
10 Most Used Excel Formula
• 10 Most Used Excel For...
*Most Imporant Excel Formuls Tutorials*
Learn Vlookup Formula For Beginners in Excel
• Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews
• 5 Excel Questions Aske...
Create Speedometer Chart In Excel
• Create Speedometer Cha...
Learn the Basic of Excel for Beginners || Part 2
• Learn the Basic of Exc...
Create Pareto Chart In Excel
• Create Pareto Chart In...
How to Create Dashboard in Excel
• How to Create Dashboar...
Excel Interview Questions & Answers
• Excel Interview Questi...

[@excel_master_habib]

thanks

[@GuruJii]

Welcome :)

[@abd1308]

awesome

[@GuruJii]

+Abdul Samad welcome