Enter your email address to download and customize spreadsheets for free
There are several alternatives to sunburst charts for visualizing hierarchies and relationships. Some of these include:
1. Treemaps: These are used to display hierarchical data as a set of nested rectangles. Each branch of the tree is given a rectangle, which is then tiled with smaller rectangles representing sub-branches.
2. Hierarchical Edge Bundling: This method visualizes hierarchical relationships by connecting nodes of a graph, which represent entities, with curved lines, which represent relationships.
3. Dendrograms: These are tree-like diagrams used to represent the distribution of a hierarchical clustering. The branches represent clusters that have been merged together, and the height of the branches tells you about the distance at which clusters were merged.
4. Circle Packing: This is a method where circles are packed together to represent hierarchical data. The size of each circle can be used to represent a quantitative variable.
5. Chord Diagrams: These are used to display the inter-relationships between data in a matrix. The data are arranged radially around a circle with the relationships between the points typically drawn as arcs connecting the data.
Question was asked on:
Sunburst charts are difficult to create but useful to visualize the relationship between hierarchies. Here are two sunburst charts: a single sunburst, which shows a team hierarchy across divisions, teams, roles, and team members, as well as dual sunbursts. In this example, we compare actual sales versus target sales, and how the profits and losses break out between months, weeks, and regions.
Asked on the following spreadsheet:
Need new charts and graphs for hard-to-visualize situations? Enter your data into fully customizable sunburst charts, heat maps, bullet charts to visu...
Download free weekly spreadsheets
Enter your email address to download and customize spreadsheets for free
Not for commercial use
Download 'Ultimate Charts (Part 4) ' spreadsheet — 17 sheets
+39 more spreadsheets per quarter
that's $3 per spreadsheet
/ Quarterly
Commercial use allowed. View other plans
Download the Ultimate Gantt Collection spreadsheet to sync your employees and increase productivity. The collection includes four types of Gantt charts. The first two tools are project-based Gantt charts organized by task and by employee. The third tool is a Gantt chart used to schedule reservations. The fourth tool is a Gantt chart used to track inventory usage and costs.
Need to create map charts in Excel or Google Sheets? Our Ultimate World Map Collection includes a filterable world map chart, filterable map charts for each major continent, including North America, South America, Asia, Europe, Africa, and Oceania, and a filterable map chart for the United States, which on Excel can be customized to any country.
How to effectively show the investment and reward opportunities of a new venture or project? Use our "Ultimate Startup Pro Forma" model to showcase a new proposal and display its cost, revenue, and at what point cash flows will become positive and reach the critical "break-even point."
We've created a new collection of more advanced and visually appealing spreadsheet charts to save hours of time. Included in this collection are: bar chart variations, sales funnel variations, pie chart variations, world map, step change charts, variance charts, scatter chart, and radar charts, all easily editable and conveniently linked to data input tables.
Are loan repayments confusing and complex to keep track of? Use our Ultimate Loan Spreadsheet to track and estimate how much principle of a loan is owed. Use this spreadsheet to analyze: home, car, student and commercial loans. Plus, analyze whether refinancing a loan is an advantage. As a bonus, loan amortization graphs illustrate the specific loan amortization schedule.
Need to visualize your data? Use this new Ultimate Charts resource for premade and fully customizable Marimekko charts, bubble charts, Pareto analysis charts, stock charts, vertical bar charts, and histogram charts to visualize the distribution of numbers, unique values, and date ranges.
Struggle with spreadsheet visualizations? Use our comprehensive charts template to save time and hours of work and create beautiful charts and graphs for reports and analysis. This template contains a variety of commonly used charts as well as dashboards for excellent and quick visualization.
Enhance your presentations with detailed maps of regions that your business is involved in. With maps of hundreds of countries around the world, organized by continents, you can highlight what’s important to your market and even visualize your future expansion.