Map Chart Settlement For Free

(bright music) In this video, I'm going to show you how to create a dynamic map, which shows any KPI that you want by geography for a specific company, division or product. So basically we're going to be adding interactivity to the map. Let's set this up from scratch. This is my small sample data. I have information on three different divisions, utility, productivity, and game. I'm showing revenue by these regions. I want to visualize this on a map and I want to do it in a dynamic way so that I can switch my view between these three different divisions and then see the revenue associated with that region. The technique that I'm going to use here is very simple. And you can apply it no matter what type of regions or countries that you're going to show. So you need to follow basically the same technique, just change things up a bit so that it matches the geographical locations that you want to show. Now, that technique is to use a scatterplot with a background image. And later we're going to switch that scatterplot to a bubble chart. Because bubble chart is basically a scatterplot with an additional dimension. So remember, a scatterplot has values on the x and the y-axis. And those are what we're going to use to find out the position of North America, South America and so on, on the map. Because right now revenue is not going to help us with the position of where North America is sitting on this background image. So that's something that we need to set up once. Now, obviously, depending on the number of regions that you want to show, the number of countries that you have, you're going to have more work. Because you need to do that set up once at the beginning. Once you do the work, you can actually use that as your own template and then show any KPI that you want to show on the map. First off, what I'm going to do is to insert a blank scatterplot. So I'm not going to click anywhere in this dataset. I'm just going to click outside the dataset and insert a scatterplot. Now the reason I'm doing that is because right now I don't have any values for my x and y-axis. I just have the revenue, which is going to be the size of my bubble, but I haven't defined the location of these. And I'd rather first see the type of map that I'm going to be using, or choose that map, and then decide on the x and y values for each of these regions. To find a map, you can double-click here, activate the fill options, but we don't want a color. We want to use a picture. You could already have a picture in the company that you can use. So you could click on File and select that picture. You could copy paste it from the clipboard, or you can look online for it. I'm actually going to test this option and look for something online. For the Bing image search, let's put vector map, and I want a world map and I want it to be blue. So let's see if they have anything available there. So you can see by default, it looks for creative commons only. This means that you can use it for...