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.
Hamilton, St Lucie, and St johns plot fine for me. Lake County is one I cannot plot.
williambryantFDOT, this is how we have them set in our excel file:
County Alachua County, Florida Baker County, Florida Bay County, Florida Bradford County, Florida Brevard County, Florida Broward County, Florida Calhoun County, Florida Charlotte County, Florida Citrus County, Florida Clay County, Florida Collier County, Florida Columbia County, Florida Miami-Dade County, Florida DeSoto County, Florida Dixie County, Florida Duval County, Florida Escambia County, Florida Flagler County, Florida Franklin County, Florida Gadsden County, Florida Gilchrist County, Florida Glades County, Florida Gulf County, Florida Hamilton County, Florida Hardee County, Florida Hendry County, Florida Hernando County, Florida Highlands County, Florida Hillsborough County, Florida Holmes County, Florida Indian River County, Florida Jackson County, Florida Jefferson County, Florida Lafayette County, Florida Lake County, Florida Lee County, Florida Leon County, Florida Levy County, Florida Liberty County, Florida Madison County, Florida Manatee County, Florida Marion County, Florida Martin County, Florida Monroe County, Florida Nassau County, Florida Okaloosa County, Florida Okeechobee County, Florida Orange County, Florida Osceola County, Florida Palm Beach County, Florida Pasco County, Florida Pinellas County, Florida Polk County, Florida Putnam County, Florida St. Johns County, Florida St. Lucie County, Florida Santa Rosa County, Florida Sarasota County, Florida Seminole County, Florida Sumter County, Florida Suwannee County, Florida Taylor County, Florida Union County, Florida Volusia County, Florida Wakulla County, Florida Walton County, Florida Washington County, Florida Using your list, highlight the counties, go to the data tab, then select geography
https://support.microsoft.com/en-us/office/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358b593b
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
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?
