Excel Map is not picking up all states.

[Livin404]

I need to use MAPS in Excel, and I know I'm not missing in steps. There are five States that have data but Excel is not flagging them. I can get them all to work if I were to special them out. However, that wouldn't be a viable option since I'm using splicers and all my country I'm able to us the country code. Is there a link I can submit a help ticket to Microsoft 365?

Thank you,

I put my list in the attached drop box.

Dropbox

 

[johnny51981]

I'm going to guess that it is due to those State Abbreviations also being other words or used for something other than a State, so Excel can't process it. Best to use the full spelling of each for the Map, and then abbreviation if you need it for display purposes.

 

[Livin404]

I'm going to guess that it is due to those State Abbreviations also being other words or used for something other than a State, so Excel can't process it. Best to use the full spelling of each for the Map, and then abbreviation if you need it for display purposes.

Thank you I thought that may be the case.