{"id":3521,"date":"2020-07-22T01:56:36","date_gmt":"2020-07-21T23:56:36","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3521"},"modified":"2024-05-18T16:51:04","modified_gmt":"2024-05-18T14:51:04","slug":"create-sunburst-chart-excel-2016","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-sunburst-chart-excel-2016\/","title":{"rendered":"Create an Excel Sunburst Chart With Excel 2016"},"content":{"rendered":"<p><strong>Excel Sunburst Charts<\/strong> are one of the many new Charts available only in Excel 2016.<\/p>\n<p>They are\u00a0<strong>very visual<\/strong> as it can easily show you <strong>hierarchical data<\/strong>, like having a table with different levels of categorization.<\/p>\n<p>In this article, you will be introduced to the following concepts regarding an Excel Sunburst Chart:<\/p>\n<ul>\n<li><strong><a href=\"#what-is-an-excel-sunburst-chart\">What is an Excel Sunburst Chart?<\/a><\/strong><\/li>\n<li><a href=\"#how-to-create-a-sunburst-chart-in-excel-2016\"><strong>How to Create a Sunburst Chart in Excel 2016?<\/strong><\/a><\/li>\n<li><a href=\"#advantages-and-disadvantages\"><strong>Advantages and Disadvantages<\/strong><\/a><\/li>\n<li><strong><a href=\"#key-tips-&amp;-tricks\">Key Tips &amp; Tricks<\/a><\/strong><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>Let&#8217;s look into each of these points one-by-one!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"what-is-an-excel-sunburst-chart\"><\/a>What is an Excel Sunburst Chart?<\/strong><\/h3>\n<p>Excel Sunburst Chart is a built-in chart available in Excel 2016 that is used to display a<strong> hierarchical structure data\u00a0<\/strong>in circular form.<\/p>\n<p>Just like a doughnut chart, Sunburst Chart is also used to <strong>display a part of the whole data <\/strong>and compare relative sizes. But it can <strong>also show the relationships<\/strong> in the hierarchy.<\/p>\n<p>This is how an <strong>Excel Sunburst Chart<\/strong> looks like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3562\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"483\" height=\"324\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png 483w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04-300x201.png 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/a><\/p>\n<p>Since this chart looks somewhat like an <strong>exploding sun<\/strong>, it is called a Sunburst Chart.<\/p>\n<p>Each level of the <strong>hierarchy is represented by a circle<\/strong> or ring with the<strong> innermost ring<\/strong> representing the top of hierarchy data and\u00a0the <strong>outermost ring\u00a0<\/strong>represents the last hierarchy.<\/p>\n<p>Each <strong>group is represented by a different color<\/strong> and the <strong>subgroups are represented by a division<\/strong>. In the <strong>example<\/strong> above, January is represented by blue color and the subgroups like week and region are represented by different divisions.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"how-to-create-a-sunburst-chart-in-excel-2016\"><\/a>How to Create a Sunburst Chart in Excel 2016?<\/strong><\/h3>\n<p><strong><span style=\"color: #ff0000\">Example 1:<\/span><\/strong><\/p>\n<p>In the table, you have sales data containing the month, week, region, and sales amount.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-00.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3558\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-00.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"351\" height=\"400\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-00.png 351w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-00-263x300.png 263w\" sizes=\"(max-width: 351px) 100vw, 351px\" \/><\/a><\/p>\n<p><strong>Using this table, I show you how easy it is to insert an Excel Sunburst Chart using Excel 2016.<\/strong><\/p>\n<p><em>To upgrade to Excel 2016 you can use this link here: <strong><a href=\"https:\/\/www.microsoftstore.com\/store\/msusa\/en_US\/cat\/categoryID.68155000?icid=en_US_homepage_whatsnew_2_OfficeCompare_160607\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Microsoft Office 2016<\/a><\/strong><\/em><\/p>\n\n<p>Watch it on <strong>YouTube<\/strong> and give it a thumbs-up!<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/oC-4G5reBuw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\">Follow the step-by-step tutorial below on how to create a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">Sunburst Chart in Excel<\/a> 2016 and make sure to download the Excel Workbook to follow along:<\/p>\n<p class=\"line-two\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Sunburst-Chart-1.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-1.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Sunburst-Chart-1.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Highlight your table\u00a0and go to <em><strong>Insert &gt; Recommended Charts<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-01.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3559\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-01.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"357\" height=\"403\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-01.png 357w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-01-266x300.png 266w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-02.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3560\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-02.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"451\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-02.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-02-300x89.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select <em><strong>All Charts &gt; Sunburst\u00a0&gt; OK<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3561\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-03.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"632\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-03.png 632w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-03-300x270.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Now you have your<strong>\u00a0Sunburst\u00a0Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3562\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"483\" height=\"324\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04.png 483w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-04-300x201.png 300w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span>\u00a0You can further <strong>customize the look and feel<\/strong> of your Sunburst\u00a0Chart, by going to\u00a0<em><strong>Chart Tools &gt;\u00a0Design \/ Format<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3563\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"1179\" height=\"137\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05.png 1179w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05-300x35.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05-1024x119.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-05-768x89.png 768w\" sizes=\"(max-width: 1179px) 100vw, 1179px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong><\/span>\u00a0In our example, let us go to <em><strong>Chart Tools &gt;\u00a0Design\u00a0<\/strong><\/em>and pick one of the alternate designs.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-06.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3564\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-06.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"783\" height=\"137\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-06.png 783w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-06-300x52.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-06-768x134.png 768w\" sizes=\"(max-width: 783px) 100vw, 783px\" \/><\/a><\/p>\n<p>Now you have your beautiful looking Sunburst\u00a0chart and you can quickly point out to your management\u00a0where the biggest slice of the pie would be on&#8230;<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-07.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-3565\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-07.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"654\" height=\"441\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-07.png 654w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Sunburst-Chart-07-300x202.png 300w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/a><\/p>\n<p>Let&#8217;s take a look at another example!<\/p>\n<p><strong><span style=\"color: #ff0000\">Example 2:<\/span><\/strong><\/p>\n<p>In the table below, you have the number of employees in a company based on the company organizational structure.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/e64aff763cb342f0b55b7a43d3bec812.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18714\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/e64aff763cb342f0b55b7a43d3bec812.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"341\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/e64aff763cb342f0b55b7a43d3bec812.png 341w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/e64aff763cb342f0b55b7a43d3bec812-284x300.png 284w\" sizes=\"(max-width: 341px) 100vw, 341px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Select the <strong>Data Table<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-339.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18726\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-339.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"342\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-339.png 342w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-339-271x300.png 271w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong> <\/span>Go to <strong>Insert<\/strong> &gt; <strong>Hierarchy Chart<\/strong> &gt; <strong>Sunburst Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-335.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18721\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-335.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"795\" height=\"304\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-335.png 795w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-335-300x115.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-335-768x294.png 768w\" sizes=\"(max-width: 795px) 100vw, 795px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong> <\/span>Your <strong>Sunburst Chart<\/strong> is ready!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-341.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18727\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-341.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"498\" height=\"333\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-341.png 498w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-341-300x201.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>In this chart, you can see the<strong> proportionate number of employees<\/strong> in each department and subdivision.<\/p>\n<p>It is clear that the<strong> maximum number of employees is in the technical<\/strong> department and the<strong> least number is in the Management<\/strong> department.<\/p>\n<p>You can even add Legends to your chart.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong> <\/span>Go to <strong>Chart Design<\/strong> &gt; <strong>Add Chart Element<\/strong> &gt; <strong>Legend<\/strong> &gt; <strong>Left<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-337.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone wp-image-18723 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-337-e1595429234471.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"377\" height=\"439\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-337-e1595429234471.png 377w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-337-e1595429234471-258x300.png 258w\" sizes=\"(max-width: 377px) 100vw, 377px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong> <\/span><strong>Legend<\/strong> to will added to the left of your Chart.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-340.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18728\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-340.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"498\" height=\"334\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-340.png 498w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-340-300x201.png 300w\" sizes=\"(max-width: 498px) 100vw, 498px\" \/><\/a><\/p>\n<p>By default, the category name will b displayed on the chart. You can even add value to it.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 5:<\/strong> <\/span>Go to<strong> Chart Design<\/strong> &gt;\u00a0 <strong>Add Chart Element<\/strong> &gt; <strong>Data Labels<\/strong> &gt; <strong>More Data Label Options<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-342.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18730\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-342.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"382\" height=\"309\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-342.png 382w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-342-300x243.png 300w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 6:<\/strong> <\/span>In the <strong>Format Data Labels<\/strong> dialog box, Check the <strong>Value<\/strong> box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-343.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone size-full wp-image-18731\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-343.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"285\" height=\"443\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-343.png 285w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-343-193x300.png 193w\" sizes=\"(max-width: 285px) 100vw, 285px\" \/><\/a><\/p>\n<p>Value will be displayed next to the category name:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-344.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Sunburst Chart With Excel 2016\" class=\"alignnone wp-image-18732 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-344.png\" alt=\"Create an Excel Sunburst Chart With Excel 2016\" width=\"543\" height=\"372\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-344.png 543w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/07\/Screenshot-344-300x206.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/a><\/p>\n<p>Now that you have learned how to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/funnel-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">create a Sunburst Chart<\/a> in Excel, let&#8217;s move forward and know about the advantages and disadvantages of using them.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"advantages-and-disadvantages\"><\/a>Advantages and Disadvantages<\/strong><\/h3>\n<p>The <strong>advantages<\/strong> of using an Excel Sunburst Chart:<\/p>\n<ul>\n<li>It can be used to show relationships in the hierarchy.<\/li>\n<li>It can be used to show the breakdown of different categories.<\/li>\n<\/ul>\n<p>The <strong>disadvantages<\/strong> of using a Sunburst Chart Excel are:<\/p>\n<ul>\n<li>It is hard to display labels on the Sunburst Chart.<\/li>\n<li>Data must be sorted by category.<\/li>\n<li>Not many options for formatting and customization.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"key-tips-&amp;-tricks\"><\/a>Key Tips &amp; Tricks<\/strong><\/h3>\n<p>There are a <strong>few things you should keep in mind<\/strong> when you are working <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-spine-chart\/\" target=\"_blank\" rel=\"noopener\">with Sunburst Charts<\/a><\/p>\n<ul>\n<li>There should be at least<strong> two levels of hierarchy<\/strong> for Excel to create these charts.<\/li>\n<li>Your data should <strong>not contain subtotal values<\/strong> as this will distort your chart.<br \/>\n<em><em>Excel only needs data at the lowest level of the hierarchy to create Sunburst Charts.<\/em><\/em><\/li>\n<li>Do not sort the data based only on the lowest level of hierarchy.<br \/>\nFirst, <strong>sort them based on the first level<\/strong> of the hierarchy and then the last level.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"conclusion\"><\/a>Conclusion<\/strong><\/h3>\n<p>In this article, we have discussed this <strong>new chart in Excel 2016 &#8211; Sunburst Chart<\/strong>, a step-by-step tutorial on how to create and format it and its advantages and disadvantages.<\/p>\n<p>You can learn more about the new charts introduced in Excel 2016 by <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/excel-2016-charts\/\" target=\"_blank\" rel=\"noopener noreferrer\">clicking here<\/a><\/strong>.<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/61-excel-charts-examples\/\" target=\"_blank\" rel=\"noopener\">61 Excel Charts Examples!<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/project-milestone-chart-using-excel\/\" target=\"_blank\" rel=\"noopener\">Project Milestone Chart Using Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pivot-chart-settings\/\" target=\"_blank\" rel=\"noopener\">Pivot Chart Settings<\/a><\/li>\n<\/ul>\n<p><span style=\"color: #0000ff\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" alt=\"Connect Slicers to Multiple Excel Pivot Tables\" title=\"Connect Slicers to Multiple Excel Pivot Tables\" class=\"alignnone wp-image-5924 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Sunburst Charts are one of the many new Charts available only in Excel 2016. They are\u00a0very visual as it can easily show you hierarchical data, like having a table with different levels of categorization. In this article, you will be introduced to the following concepts regarding an Excel Sunburst Chart: What is an Excel [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17131,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Create an Excel Sunburst Chart With Excel 2016","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,127],"tags":[136,140,675],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3521"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3521"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17131"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}