![]() Your label fields will come first, and you will likely have several (otherwise you’ll just created a donut chart!). The first step to creating any chart is prepping your data.įor a sunburst chart, the structure of your data is a little different than from other charts. It should be noted that neither of these charts can be created using Pivot Charts – which, for reasons which will become apparent, is a little frustrating. Again, not ideal, and never really used it in the end. I’ve before created a pseudo-Sunburst Chart by nesting doughnut charts, but is far from ideal, and as for Tree-Map, I believe the last time I looked at trying to do this it involved loading Java based add-ins or similar. These are interesting ones to look at, as previously, it was incredibly difficult to create these in Excel. Today, I’m going to talk about the Sunburst & Tree Map Chart Types. I’ve already spoken about Waterfall Charts, and was impressed at the speed and ease of creating these, compared to the method you had to use before. However, the initial release of Excel 2016 gave us a 2 new chart types, with 2 more released as part of a Jan 2016 Update. It’s been many years since Excel has given us any meaningful new Chart Types (I’m not counting Sparkline Charts) Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |