According to the official document, if you use data where there might be more than one similar location in the world, map charts can’t necessarily tell the difference without more guidance. If possible, add a higher-level detail column to your data.
You could try to add more detail columns like zip codes.
More information, please refer to “Create a Map chart in Excel”.
If you have any update, please post back.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.