Dynamic Tree Map Chart Tutorial in Google Sheets!
Dynamic Tree Map charts are a great way to elevate any dashboard. The formatting isn’t necessarily intuitive though so you have to know how to reformat your original dataset into a way that works for a Tree Map chart.
In this video, I show you how to create a Static Tree Map chart that requires manual updating (the traditional way). I also show you how to create a dynamic Tree Map chart that will automatically update with your dataset no matter what additional fields or edits are made!
00:00 - Intro
00:55 - Required Format
01:48 - Static Tree Map: Formula Creation
05:06 - Static Tree Map: Add Formulas to Rest of Dataset
06:25 - Static Tree Map: Format Data
06:34 - Static Tree Map: Create Chart
08:26 - Dynamic Tree Map: Overview
09:52 - Dynamic Tree Map: Region Helper Columns
13:31 - Dynamic Tree Map: Associate Helper Columns
15:06 - Dynamic Tree Map: Combining Helper Columns
16:35 - Dynamic Tree Map: Create Chart
17:48 - Outro