Share via

I'm Trying to heat map Washington state by county (based on this % data) but it keeps mapping the entire globe instead of the single state

Anonymous
2024-02-20T08:07:09+00:00
state County Percent
Washington ADAMS 0%
Washington ASOTIN 0%
Washington BENTON 1%
Washington CHELAN 0%
Washington CLALLAM 0%
Washington CLARK 1%
Washington COWLITZ 0%
Washington DOUGLAS 0%
Washington FERRY 0%
Washington FRANKLIN 0%
Washington GRANT 0%
Washington GRAYS HARBOR 0%
Washington ISLAND 0%
Washington JEFFERSON 0%
Washington KING 11%
Washington KITSAP 1%
Washington KITTITAS 0%
Washington KLICKITAT 0%
Washington LEWIS 0%
Washington LINCOLN 0%
Washington MASON 0%
Washington OKANOGAN 0%
Washington PACIFIC 0%
Washington PEND OREILLE 0%
Washington PIERCE 3%
Washington SAN JUAN 0%
Washington SKAGIT 0%
Washington SKAMANIA 0%
Washington SNOHOMISH 3%
Washington SPOKANE 2%
Washington STEVENS 0%
Washington THURSTON 1%
Washington WALLA WALLA 0%
Washington WHATCOM 1%
Washington WHITMAN 0%
Washington YAKIMA 1%
Washington ADAMS 0%
Washington ASOTIN 0%
Washington BENTON 2%
Washington CHELAN 1%
Washington CLALLAM 1%
Washington CLARK 4%
Washington COLUMBIA 0%
Washington COWLITZ 1%
Washington DOUGLAS 0%
Washington FERRY 0%
Washington FRANKLIN 0%
Washington GARFIELD 0%
Washington GRANT 1%
Washington GRAYS HARBOR 1%
Washington ISLAND 1%
Washington JEFFERSON 0%
Washington KING 28%
Washington KITSAP 2%
Washington KITTITAS 0%
Washington KLICKITAT 0%
Washington LEWIS 1%
Washington LINCOLN 0%
Washington MASON 0%
Washington OKANOGAN 0%
Washington PACIFIC 0%
Washington PEND OREILLE 0%
Washington PIERCE 8%
Washington SAN JUAN 0%
Washington SKAGIT 1%
Washington SKAMANIA 0%
Washington SNOHOMISH 7%
Washington SPOKANE 5%
Washington STEVENS 0%
Washington THURSTON 2%
Washington WAHKIAKUM 0%
Washington WALLA WALLA 1%
Washington WHATCOM 2%
Washington WHITMAN 0%
Washington YAKIMA 2%
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-02-20T09:00:08+00:00

    Yup that solved it. Thank you!

    0 comments
  2. riny 20,870 Reputation points Volunteer Moderator
    2024-02-20T08:45:44+00:00

    First, make sure you verify all the county names with the Geography data type. And then create the filled map from the list of counties. This is what I get.

    0 comments