Forum Discussion
Map Charts with Counties
Okay, so I'm making a project to show data for each county in Kentucky. My table is formatted with Column A having the heading "County" and Column B having the heading "Acres Used for Farm Land"--the...
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:
