Map Counties within State

[VeronicaN350]

Hi everyone, 

I am trying to map counties within California, and when I choose "State/Province" for mapping the area, it shows me the entire world map. When I choose "Country/Region" it shows me all of the US. I am trying to only have a map of California. Is this possible? 

[#2]

@VeronicaN350 

California is difficult to pull off because there's a lot of counties and the map chart is limited with colors.

Here's what my Format Data Series menu looks like:

Here's my data arrangement w/chart:

[#3 · Accepted solution]

@VeronicaN350 

Variant

is in attached.

[#4]

Thank you so much for your help. Yes, I saw similar posts for different states, and it seems like California is a different kind of beast!

[#5]

Thank you! I am going to give that a try and report back. This gives me hope it is possible!