![create line chart in excel for mac create line chart in excel for mac](https://i.ytimg.com/vi/99XaQFINf_Q/maxresdefault.jpg)
If possible, add another column to your data to help Maps know where to look. Please note that, If you use data where there might be more than one similar location in the world, Maps can’t necessarily tell the difference without more guidance.
#Create line chart in excel for mac series#
This will also expose the Map chart specific Series options. You can also Right-Click on the chart and select from the menu options there, or double-click the chart to launch the Format Object Task Pane, which will appear on the right-hand side of the Excel window. Just click on the Map, then choose from the Design or Format tabs in the Chart Tools ribbon tab. Once your map has been created you can easily adjust its design.
![create line chart in excel for mac create line chart in excel for mac](https://support.content.office.net/en-us/media/c3e64d83-ca39-481b-ae45-f879ac6cc131.png)
Once you press OK, Excel will insert your map. Step 3: Select Map ChartĬlick Insert > Charts > Recommended Charts, or Insert > Charts > Maps, then select the map chart.ĭepending on your data, Excel will preview either a value or category map. Start with one column for your geographic location (country/region, state or province, county or postal code), then your numeric or categorical values in the second column. In the following example, Countries by Category, the categories are displayed using a standard legend to show groups or affiliations.Ĭreate a Map chart Step 1: Create a TableĬreate a table or you can copy the following data that we used for our examples, or set up your own in a similar fashion. The colour for each region is dictated by where along the spectrum its value falls with respect to the others. The values represent the total population in each country, with each portrayed using a gradient spectrum of two colours. Categories are represented by different colours.įor example, Countries by Population uses values. Values are represented by slight variations of two to three colours. Maps can display both values and categories, and they each have different ways of displaying colour. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes.īefore the start, do have a look on “ What’s new in Excel 2019 for Windows“ Display Values vs. You can use a Map Chart to compare values and show categories across geographical regions.