Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

Map Counties within State

Copper Contributor

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? 

VeronicaN350_0-1705080555135.png

VeronicaN350_0-1705084319579.png

 

 

4 Replies

@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:

Patrick2788_0-1705089433309.png

Here's my data arrangement w/chart:

Patrick2788_1-1705089514773.png

 

 

 

best response confirmed by VeronicaN350 (Copper Contributor)
Solution

@VeronicaN350 

Variant

image.png

is in attached.

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!
Thank you! I am going to give that a try and report back. This gives me hope it is possible!
1 best response

Accepted Solutions
best response confirmed by VeronicaN350 (Copper Contributor)
Solution

@VeronicaN350 

Variant

image.png

is in attached.

View solution in original post