![]() STEP 1:Highlight your table and go to Insert > Recommended Charts Watch it on YouTube and give it a thumbs-up! To upgrade to Excel 2016 you can use this link here: Microsoft Office 2016 Using this table, I show you how easy it is to insert an Excel Sunburst Chart using Excel 2016. ![]() In the table, you have sales data containing the month, week, region, and sales amount. How to Create a Sunburst Chart in Excel 2016? In the example above, January is represented by blue color and the subgroups like week and region are represented by different divisions. ![]() Since this chart looks somewhat like an exploding sun, it is called a Sunburst Chart.Įach level of the hierarchy is represented by a circle or ring with the innermost ring representing the top of hierarchy data and the outermost ring represents the last hierarchy.Įach group is represented by a different color and the subgroups are represented by a division. This is how an Excel Sunburst Chart looks like: But it can also show the relationships in the hierarchy. Just like a doughnut chart, Sunburst Chart is also used to display a part of the whole data and compare relative sizes. Let’s look into each of these points one-by-one!Įxcel Sunburst Chart is a built-in chart available in Excel 2016 that is used to display a hierarchical structure data in circular form.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |