![]() This is how we can plot different cities on a map from the same state in Excel. The higher the population of a city, the more the color will shift towards the darker blue.On that map, the location of each city is highlighted and the population value of the cities is marked with Data Legend. Because all of the cities in the range of cells B5:B66 is in New York State. After clicking Maps, you will notice that the map of New York State appears.Then from the Insert tab, click on the Maps in the Charts. Now select both the range of cells C5:C66 and the range of cells B5:B66.After clicking the Population, the range of cells C5:C66 is now filled with the population value of the cities mentioned in the range of cells B5:B66.Then, there will be an Insert Data sign on the corner of the cell and a Geographic card sign on the left side of each cell.After selecting the data, go to the Data tab, and from the Data tab, click on the Geographic Data from the Data Types group.To do this, first, select the range of cells B5:B66, by pressing the Shift+Ctrl+Down Arrow key.At first, we need to convert the dataset which is the list of cities in New York state from the General data type to the Geographic data type.In this example, we will plot 62 cities from the same states and their population information in a single chart using the Map Chart. The more population of a city, the color will shift towards the darker blue.Įxample 2: Plotting Cities from Same State After clicking Charts, you will notice that the map of the United States of America appears.Now select both the range of cells C5:C284 and the range of cells B5:B284, from the Insert tab, and click on the Maps in the Charts group.After clicking the Population, the range of cells C5:C284 is now filled with the population value of the cities mentioned in the range of cells B5:B284.Then click on the Insert Data sign and select the Population option from the menu.And a Geographic card sign on the left side of each cell. Then, there will be an Insert Data sign on the corner of the cell.After selecting the data, go to the Data tab, and from the Data tab, click on the Geographic Data from the Data Types group. ![]() To do this, first, select the range of cells B5:B284, by pressing the Shift+Ctrl+Down Arrow key.At first, we need to convert the dataset which is the list of cities from the General data type to the Geographic data type.And their population information in a single chart using the Map Chart. In this example, we will plot 280 cities from different states. ![]() Map chart is an additional type of chart in Excel which helps you to plot information based on geographic locations.Įxample 1: Plotting Cities from Different States ![]() And another list of 62 cities from New York state. The first dataset contains a list of 280 cities in different states. But before doing any of the methods, we need to convert the General type data to a Geographic type of data. The map chart and the 3D map chart are going to use plotting the information. We will plot information related to the population of cities in different states and also in the same state. 2 Easy Methods to Plot Cities on a Map in Excel
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |