Map Chart in Excel (Table of Contents)
- Introduction to Map Nautical chart in Excel
- How to Create Map Nautical chart in Excel?
Introduction to Map Chart in Excel
It is very often seen that you have data associated with geographical regions, and you desire a nice chart to show up all the values for those geographical locations. You may accept sales for unlike geolocations or product details. Also, nosotros might non always have tools like ArcGIS or QGIS to make good graphical maps. Moreover, it takes a lot of fourth dimension to generate maps through these tools as well. Now, we can utilise excel maps to generate fancy maps and map charts for such type of data and that too within a jiffy when your data is prepare. Utilize these map charts whenever you take data in sort of geographical regions such equally countries/continents, urban center, state, postal codes, county, etc.
This commodity will come across how to create map charts under excel and that too in minutes using the excel maps chart option.
How to Create Map Nautical chart in Excel?
Map Chart in Excel is very uncomplicated and easy. Let'due south understand how to Create the Map Chart in Excel with a few applied steps.
Steps for Creating Map Chart in Excel
Let's take a simple example of a map nautical chart to just go an overview of how this works in Excel. Suppose we have data as shown below, which contains our sales values for different countries.
Footstep 1: Click anywhere on the table and go to the ribbon placed at the upper pane. Select Inset, and in chart options, you lot can see the Maps pick there.
Footstep 2: Click on the Maps and select an option called Filled Map. You lot will run into a blank graph coming up. See the screenshots below.
Step 3: On theDesign tab, click on the Select Information option. It will permit y'all to select the information for Map Chart.
Stride iv: A new popular-up window named "Select Information Source". Hither, you volition add your data.
Pace 5: Nether Nautical chart Data Range, select the data from prison cell A1 to cell B6. Excel is smart enough to populate the sales values into series and Country into a category. Click theOK button once done with editing the information.
Step 6: Y'all will see a map graph as shown in the paradigm beneath. Information technology highlights that expanse where your sales have happened (on the world map, you tin can say).
Step 7: Now, Right-Click on the nautical chart area, y'all will see a list of operations available for this nautical chart. Out of all those operations, select the Format Chart Area option, which is situated at the bottom-nigh part of the operations listing. Click on the Format Chart Area selection. It allows yous to format the chart area.
Footstep 8: This will open up a new pane called Format Chart Area. Here you tin customize the Make full color for this nautical chart, or you can resize the surface area of this chart or add labels to the chart and the centrality. Run across the supportive screenshot below:
Stride 9: Click on the navigation down arrow available besides the Nautical chart Options. Information technology volition open up several chart options. Click on Nautical chart Title and add together the title equally "Country-Wise Sales" for this chart. Also, select the final choice bachelor, namely Series "Sales Amount". This allows you to brand customized changes into series information (numeric values in this case).
Step x: Once yous click on Serial "Sales Amount", it will open up Series Options using which yous tin can customize your data. Like under Series Options, you can change the Projection of this map; you tin can gear up the Surface area for this map and add together Labels to the map also (remember each series value has a land proper name labeled). However, the nearly interesting and of import feature is, we can change the color of series values.
Footstep xi: Nether Series Options, click on theSeries Color option. It volition open a list of colors that are used by default while creating this map chart. It ideally chooses the following color combination by default.
Minimum and Maximum in these formatting options are meant that the minimum series value will have a light color and the Maximum series value volition have nighttime colour and so that it gives a better agreement through the graph itself (No need to go to the values table).
We are going to customize this sequential two-color setting.
Step 12: Click on the dropdown and select the Diverging (iii-Color) option nether Series Color. It allows you to differentiate your series into 3 dissimilar patterns: Minimum, Midpoint, and Maximum (based on the series's values and colours).
Step 13: Cull the following colour every bit shown in the screenshot for each of the Minimum, Midpoint and Maximum serial value and see the change in the graph.
Conspicuously, this Diverging (iii-color) system works more decently than the Sequential (ii-color) system, and y'all can easily identify the areas with the lowest sales, medium sales, and highest sales happen.
This is it from this article on map charts. Here we tried to cover how to create a map chart in excel 2016 and have seen some customization options available with map chart. Let's wrap things up with some points to be remembered.
Things to Remember About Map Chart in Excel
- The Map Charts are generated online based on the geocoding and region data. Therefore, information technology becomes more than of import to provide as smallest possible region information every bit possible to get acceptable data. Having said that, every time yous generate a map nautical chart, the arrangement suggests how much region (in terms of percent can be covered). If you add small region details such as city, canton, states, information technology allows the map to accept a better projection of the region, and your chart looks more accurate subsequently.
- Information technology is mandatory to have a licensed version of Microsoft Excel because this characteristic currently is non associated with the pirated/mirror versions. If you have a mirror version, you might non be able to see the option to add a map chart under Insert.
- In this article, the Microsoft Part 365 version of Excel is used (Tin Ideally be called as Excel 2016). If you are using Excel 2013, in that location are some different Add-Ins you have to enable in gild to work with Map Charts (Information technology is across the scope of this article).
Recommended Articles
This is a guide to Map Nautical chart in Excel. Here we discuss the Steps to Create a Map Chart in Excel along with practical examples and a downloadable excel template. Y'all can also go through our other suggested articles –
- Excel Combination Charts
- Marimekko Nautical chart Excel
- 3D Maps in Excel
- Histogram Chart Excel
DOWNLOAD HERE
How to Draw a Map in Excel TUTORIAL
Posted by: janetkneliking.blogspot.com