Forum Discussion
Map Charts with Counties
I am having the same issue with Counties in Florida, where some show in other states even though the series has a field with Florida listed and the county selection is via a drop box. And some counties don't even generate a map even though they are spelled correctly, like St. Johns and St. Lucie Counties.
So if I select Hamilton County from the drop down list and in the very next cell it says FL or Florida, the map chart still shows Hamilton county Iowa and not Hamilton County Florida.
Ive been having the same issue for counties in PA. Ive tried 100 different ways. Ive made county maps for PA using excel in the past, but it no longer works.
The Excel map has worked fine for years with the state in a column (Florida) and the County (Lake). It has now changed and will not plot all counties. I followed your suggestion and got 1 to plot correctly (Orange County) by putting County on the end of ones that were not plotting that worked for some others it did not (Lake) does. When I put county on the end of all of them it shows the whole USA. I only want Florida like you see below. Lake should be plotting yellow.Kevin32312
- I'm using geography data with the number of occurrences in a separate column. It's not showing the number value when I select "show" data labels
- We also did a color code for the regions and then a secondary color code for the % completion as a gray scale and by overlaying we get the final map:
SergeiBaklan I'm trying to replicate your map to show numbers of occurrences for each county. I can't get it to show the value in each county - it's only showing the color related to the number value. I compared my sheet to yours but can't seem to find what I've missed. Plus, it shows the data going over the Great Lakes....Any suggestions?
- is that Michigan, i used to be really good at state maps.
