Creating Sunburst Chart in Excel
What is a Tree Map Chart? (1/2) • A Tree Map chart is an inbuilt chart in Microsoft Excel 2016 and later versions. • A Tree Map chart is used to display Hierarchical data, in a rectangular format.
• It is used for visualization of data with multiple levels of segmentation. Email: Support@skillfinlearning.com
Mobile: 9650010925
What is a Tree Map Chart? (2/2) • A tree map chart gives a pictorial representation of how data is spread across different segments and subsegments. ➢ The top categories in the data set are represented by larger rectangles having different colors. ➢ The sub-categories within the data are shown in smaller rectangles. ➢ Their size represents the contribution to the larger rectangle. Email: Support@skillfinlearning.com
Mobile: 9650010925
Creating a Tree Map Chart - Example • Here is a table showing revenues of different categories of electronic products in different countries.
1➢ Organize Steps to create a Tree Map Chart
2➢ Insert
the data for the chart
the Tree Map Chart
3➢ Format the chart as
Email: Support@skillfinlearning.com
required
Mobile: 9650010925
1
Organize the data
•
For the Tree Map Chart, we need the data in 3 columns.
•
In our example. ➢ The first column should represent the countries ➢ The second column, the product ➢ The third column, the revenue contribution by each product
Email: Support@skillfinlearning.com
Countries USA USA USA USA USA Canada Canada Canada Canada Canada South America South America South America South America South America Africa Africa Africa Africa Africa Europe Europe Europe Europe Europe China China China China China India India India India India
Mobile: 9650010925
Products Revenues Mobile 2,970 Television 1,898 Refrigerator 1,222 Washing Machine 2,944 Air Conditioners 1,413 Mobile 693 Television 1,249 Refrigerator 5,000 Washing Machine 998 Air Conditioners 1,422 Mobile 1,188 Television 549 Refrigerator 3,339 Washing Machine 329 Air Conditioners 1,367 Mobile 495 Television 1,998 Refrigerator 2,222 Washing Machine 84 Air Conditioners 899 Mobile 1,287 Television 1,299 Refrigerator 1,278 Washing Machine 156 Air Conditioners 396 Mobile 1,782 Television 2,797 Refrigerator 3,333 Washing Machine 55 Air Conditioners 1,439 Mobile 1,436 Television 2,098 Refrigerator 5,611 Washing Machine 143 Air Conditioners 935
2
Insert the Tree Map Chart
• Once we make the selection, we get a Tree Map chart (as shown below).
• To insert a Tree Map Chart, • Click on the data table. Then Go to insert, and within the chart section click on Insert Hierarchy Chart. From the drop down select Tree Map Chart.
Email: Support@skillfinlearning.com
Mobile: 9650010925
• The large rectangle represents the countries and the smaller ones the revenue contribution by each product.
Format the Chart
3
• • • •
Remove the chart title. Remove Legends. Remove chart border. Format data labels. ➢ To Format the data Labels, Right click on the data Label and Select Format Data Labels.
Email: Support@skillfinlearning.com
Mobile: 9650010925
Select Banner
3
Format the Chart ➢ To add values, Right click on the data Label and Select Format Data Labels. ➢ Select Value
Change the color of the banners by double clicking on each rectangle
Insert a Chart title in the white space at the middle of the inner Circle. Select Value
Email: Support@skillfinlearning.com
Mobile: 9650010925
Here is the Tree Map Chart
Email: Support@skillfinlearning.com
Mobile: 9650010925
Advantages
Tree Map Chart – Advantages and Limitations
The Tree Map Chart is useful when the data set has multiple levels of segmentation.
Email: Support@skillfinlearning.com
It also cannot be used if we want to see the time pattern for multiple variables in a data set.
Mobile: 9650010925
Limitations
It gives a pictorial representation of how the data is spread across different segments.
These Charts cannot be used if the data set cannot be divided into segments and sub segments.
Want to learn more? Explore our “Data Analysts Skills Training” (DAST) course Go from beginner to an Expert in Data analytics Skills in Excel. Join this program to build your Excel analytical skill quickly through hands on project Skills you will master: ✓ Data analytics functionalities in Excel ✓ Data visualization through charts ✓ Logical analysis driven decision-making ✓ Data cleaning and improvisation methods ✓ Pivot Table analysis ✓ Professionally format datasheets ✓ Excel tips and tricks using shortcuts ✓ Excel skills for business purposes ✓ Apply data analysis on real life datasets
Coaching includes: ✓ Annual (1 year) Subscription ✓ 100+ Live Interactive Sessions ✓ Unlimited Access to Video Content ✓ Weekly Mentorship Assistance ✓ Individual Assignments Evaluation ✓ Access on Mobile and Tablet also ✓ Certificate of Completion For more details please visit Data Analyst Skills Training (DAST)
Email: Support@skillfinlearning.com
Mobile: 9650010925
Our Training approach ensures You Learn Effectively in Less Time
Email: Support@skillfinlearning.com
Mobile: 9650010925
THANK YOU
Email: Support@skillfinlearning.com
Mobile: 9650010925