So, starting with the top data set, this is ticket sales by title, by rating, by genre. I'm gonna use one to create a tree map and the other to create a sunburst chart. All right, so here we are in the tree maps and sunburst chart tab of our database exercises workbook.
And I'll show you an example of why that's so important. Second, in this one's really, really important, make sure your raw source data is already grouped and sorted before trying to create a tree map and a sunburst chart. Sunburst charts, on the other hand, are a great way to show the depth of different hierarchical levels within your data. Or when relative sizes are really important to your story. The first, use tree maps when you're only visualizing one or two hierarchical levels.
All of these example data sets have natural groupings and sub-groupings. So, some examples might be: If you wanna look at relative revenue by book title, organized by genre, and sub genre or look at the number of employees by department, by office or population by city, state and region. So these types of charts are a really great way to visualize data that has natural groups or sub-grouping. But that's all changed in 2016 with the introduction of tree maps and sunburst charts. : So, in the past, if you wanted to visualize hierarchical data, Excel was not a very good way to do that.
