Download template: [ Ссылка ]
Table of Contents:
00:00 - Intro
00:52 - Sunburst charts
02:08 - Heat maps
02:43 - Bullet charts
03:27 - Thermometer charts
04:05 - Venn Diagram
04:47 - Bell curve, milestone, and combo charts
05:31 - Outro
Need excel charts and graphs for hard-to-visualize situations? We’ve created another Ultimate Charts spreadsheet template in Excel and Google Sheets that you can download and customize to your needs. It includes fully customizable sunburst charts, heat maps, bullet charts to visualize top KPIs, thermometer charts, three and four circle Venn diagrams, filterable bell curves, milestone charts, and combo charts.
The best part is, this spreadsheet is fully customizable - meaning any field in blue can be edited to fit any use-case…whether you’re in marketing, human resources, product development, or anything else.
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. And 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.
All these inputs in blue can be customized to match your data. This could be used by a supply chain management company to track parts by their respective groupings, an HR firm to track salaries, or a sales company to account for deal sources. Watch until the end to learn more!
