Thank you! Saw Treemap as an option and wasn't able to figure it out initially. This was helpful. Always thought these look cool, glad that I (kinda) know how to do it now - gotta tweak somethings around for my specific use case
@toyclyde
2 жыл бұрын
Thank you for this explanation! You made a complicated chart setup easier to understand. I wish Google sheets made creating a tree map as easy as Google Data Studio does.
@Bosshog-WealthHealthBetterment
Жыл бұрын
Man this is a really great teaching video, thank you. I have used it to group my portfolio positions by location and type (single shares or ETFs), something I'd been struggling to get right in Google Docs. Now got it sorted. Definitely fiddly but easy once you know how. Thanks again, I'll be sure to credit your channel in my next week update :)
@NandniPrasad
Жыл бұрын
Thank you so much for make it easier to understand.
@joram3592
Жыл бұрын
Thanks (: was easy to follow!
@lylestavast7652
11 ай бұрын
Things I ran into: - my number counts were not integers, they were floating point values so I wrapped each with "=int(number)". Had to copy and paste an empty cell from elsewhere on the sheet using ctrl-v onto the top center column for some reason. Otherwise, worked like a champ.
@firdausismail3020
2 ай бұрын
so you cant do this from a pivot table?
@digilifepro
5 ай бұрын
This is helpful but it's absolutely ridiculous that Sheets can't extrapolate this on its own without making us create an entire new chart with redundancies to help Sheets figure it out?? I came upon your video because I could not figure out how to have 2 columns of data, "Name" and "Size" and simply want to see squares that are the relative size to the total, that make up the whole square. Like: Cars 40 Trucks 20 Busses 5 Moto 35 Total Vehicles 100 Is this not possible in Sheets and if so did I time travel back to 1991?
Пікірлер: 9