How to Create Editable Geo Charts in Sheets

0:01 All right, so this video is how to create a geochart in Google Sheets. And I want to start by telling you, I have absolutely been fried in the brain because it's super unintuitive. 0:12 And it ends up that the solution to geocharts when AppScript is not completed and it's not even super that useful, but you might find it incredibly useful. 0:24 Give me some feedback, and I want to help you through this because I am helping myself through it, and I'm bewildered. From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3 How hard is it to learn Google Sheets? Advanced Coding in Google Sheets for Programmers How to Get Link to a Range in Google Sheets

0:30 So, basically, what I wanted and what I got, what I started with, is I wanted a list of countries, and I want those countries to highlight on this map. 0:38 Well, this doesn't work if you just add a geochart. A geochart really is, and this is where it gets interesting. 0:47 Canada, this one works. Because secret reveal, click and drag here, there's numbers. A geochart is actually charting numbers. So we need those numbers somewhere.

0:57 Here, I'm hiding it by the chart , but honestly, most of the time, if you're gonna add a geochart to a sheet and you want somebody to fill out countries and it highlights them, you're gonna end up having two pieces of data : you're gonna have the chart and the list, but you're gonna have a Third thing, 1:13 which is where the data of that chart is actually filled out. And we can use this if is blank, we can put this on another page, do all sorts of cool stuff. How To Hide Data with Checkboxes in Google Sheets How to Create A Visually Appealing Chart

1:24 If you have an actual serious need for this and I don't fulfill it through this video, just email me or message me here in Better Sheets Echo, and I'm happy to help you through this. 1:35 I want to see what people are using. Charts for how you're using them in your templates. But here's the cool thing: I'm not going to leave you hanging dry. 1:42 Two things that I did to solve this. One is I discovered with this data , you can do cool things like population. 1:49 You can show all the population of every country and then have it have like a heat map. Well, how to do this? How To Use a 1-Cell Google Sheet Make an INTERACTIVE Pie Chart for PRIORITIES

1:55 I ended up creating it with AppScript. However, that solution is not great because if If I click on this and I click on these three dots and I edit this chart , it's blank. 2:04 The Apps Script created the chart , but now it's not editable. It's not that great. So, in order to make an editable version of this, here is the instructions. 2:14 Make this map yourself without Apps Script . Here it is. So, go down below here on BetterSheets.co, grab this template , and just do this step by step. 2:23 That's it. Create a ChatGPT Cheat Sheet Spreadsheet Create a Timer with Apps Script Make Square Cells in Google Sheets with Apps Script

That's how you create a chart , a geochart, and it actually ends up being automatic and really useful and editable. 2:33 Here's just highlighting. If you just want a country, highlight, you just need a number . Here's how to do it. What I did want to do is, and what the App Script does, and it's free for you, just grab it down below, is if you go to the at least. 2:49 Third row, I think, and you type in United States, Canada, Mexico, and we want like green, red, and red, let's say. 3:01 And we want to turn this into a chart . Well, we're on this sheet. Getting Started in Google Sheets Spreadsheet Management Make an INTERACTIVE Pie Chart for PRIORITIES

We can go to GeoChart, Build, Refresh, Map, and now it should create a value here, show the chart . 3:13 And if we go to edit chart , it's blank. It's not fungible. It's not editable. That's the one problem. So you get the chart . 3:22 You get the chart you wanted, which is this particular thing through the Apps Script . And that's really cool, I think. 3:28 However, it's not editable. So I gave you these instructions on how to do it step by step. Um and that's it. 3:39 That's the video here. Thanks for watching. Go grab it down below. Geo chart and ask me questions. This is a work in progress. Create a ChatGPT Cheat Sheet Spreadsheet Gemini is EVERYWHERE

3:47 I really want these geocharts to be really cool. I thought AppScript was going to solve all of my problems, but it isn't solving all my problems because I really do want to make these like editable and fungible. 3:56 Make it, oh, I don't want it green. I want it yellow or a different type of green or a different type of thing. 4:01 So, yeah, this video is actually not a complete tutorial. I want to know how you're using GeoCharts, how you use them in your templates, how you use them in your sheets, and I want to know what else I can do for you to help you with them. Roasting Google Sheets Gemini is EVERYWHERE

4:14 Again, I have all these step-by-step instructions on how to do it by hand. Grab the sheet below. I hope you are very happy with it.