Reporting Hierarchical Data
In previous sections, we looked at pivot tables and created dashboards using our pivot tables. We even used our pivot tables to compare and summarise our data. What we have not considered is different ways of visualising and charting our data.
In this step, we will explore treemaps and sunbursts, which simplifies visualisation and representation of hierarchical data.
It is important to remember that not all chart types are compatible with pivot tables. To use charts that are not supported by pivots, you can summarise your data from your pivot with formulas.
Treemaps
Sunbursts
Click on these links to be taken to the resources.
Join the discussion
Of these two charts available in Excel, which do you prefer and why?Use the discussion section below and let us know your thoughts. Try to respond to at least one other post and once you’re happy with your contribution, click the Mark as Complete button to check the step off, then you can move to the next step.
How to Use Microsoft Excel for Data Analysis
How to Use Microsoft Excel for Data Analysis
Reach your personal and professional goals
Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.
Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.
