Map charts show different types of information or values that apply to more than one region or country. You can use this MS Office feature, for example, if you need to show how different postal codes, states, or counties compare in terms of data. Check what version of Office you have before we show you how to make a map chart in Office.
This feature can only be used by people who have Office 2019 or Office 365. It works on Mac and Windows so you can use it on either.
How to Display Categories and Values in a Map Chart
When you make a map chart in Office to show values, you can use up to three colors to show the values. On the other hand, you can use many different colors to show categories.
You can see data values and categories in map charts, each showing color differently. Two to three colors show what the values are. Different colors stand for different groups.
You can use the Values to show how many people live in each country if you want to list them by population. You can also use the Categories chart to show countries. For each country, the data will be shown in a different color.
Four steps to building a map chart
Formatting a map chart in Microsoft Office
You can make your map chart look better when you finish the steps above. First, click on the map. Then, go to the Chart Tools tab and click on Design.
Excel has a specialized function for creating three-dimensional map charts.
You also can't add street addresses, cities, or latitude and longitude coordinates to map charts in Office. What's good is that you can look at your map charts without being connected to the internet, but if you want to add something to the map or change it, you will need to be connected to the internet.
Potential Problems with the map
It is possible to enter the data and sort it into two columns, but when you make a map chart, it will be blank. Also, sometimes the wrong countries are given for some of the data. There are places in the world with names that sound alike, so you need to give more information for the maps to find the right place. To fix this, you can add a new column to Excel and put the details that make one place different from another with a similar name.
Bonus: How to Add an Excel Table to a Word Document
MS Word documents are used to show data in the form of text, while MS Excel files are used to show data in the form of tables. But sometimes you need both kinds of information in the same document. What to do when that happens? If most of the information in the document is in text form, you can use Microsoft Word and add an Excel table to it.
The first matter you need to do is open both Microsoft Excel and Microsoft Word. If you already have certain papers, all you have to do is open them. Open both Excel and Word if you're about to start working on a document.
Both documents can be made separately, but if you make a table in Excel, here are the steps to follow to add it to Word:
1. Click the left button on the table to select it. If you're working with an existing Excel table and don't want to include the whole table's content in Word, pick the part you need.
2. The next action is to right-click the mouse and choose the Copy option.
3. To copy tabular data from Excel to Word, you need to make a Word table with the same number of rows and columns as the one in Excel.
4. In a Word document, click where you want to put the table, then click Insert Table from the Insert menu.
5. Enter the appropriate number of rows and columns in the appropriate fields, then click the OK button.
6. Now, all you have to do is paste the Excel table. In Word, click the arrow next to the Paste option after right-clicking the Home button on the left. To put an Excel table into Word, use the Paste Special option. The table will be right where you put it when you made it in Word.
7. But to keep the original look of an Excel table in a Word document, you need to paste the table as "Unformatted Unicode Text." So, choose that one from the Paste Special options that Word gives you and press OK.
Remember that a table won't look the same unless you paste it as unformatted Unicode text.
This tip can be very helpful, especially when working on long documents. Long text without pictures or explanations would be boring and hard to read. Tables are like pictures in that they can show a lot and explain a lot. People are visual creatures. So, the next time you need to write about money, statistics, or numbers in general, try putting an Excel table into Word. You'll see how much easier it would be to read and understand your document.