This can be an optional step, but skipping it may mean that Excel can’t identify one or more of your locations and the map therefore won’t cooperate, so best practice is to start here.ġ. The first step is to make sure Excel can identify the locations listed in your document. The numbers could have been any figure you are tracking, of course. In my case, I picked a few Kansas counties (sorry if I left out yours!), and their populations. Your starting place should include clearly named locations and associated figures. This Byte is inspired by two different faculty members who emailed me with this question… you know who you are, and thank you for the inspiration! Starting Place: The List How do you create a map charting figures by county, city or zip code in Excel? There are a variety of ways to tackle this question, but today I want to show you how to use data types in conjunction with the map chart type to create a chart by county in Excel. Here is a question that has been particularly popular recently.
0 Comments
Leave a Reply. |