Excel Map Great Lakes Problem

Question

Split from this thread.

Hi Rena, 

I am this same issue in excel maps. Please see below. My data in Michigan is covering the great lakes. Please let me know how I can fix this.

Answer 1

Thanks Tim,

I sent the file on the private message. Please let me know if there is anything else you may need from me.

-David

Answer 2

Hi David,

Could you share with us the worksheet in my private message? We want to test with the same file from our side.

To find the private message, access the URL https://answers.microsoft.com/en-us/privatemessage/inbox.

Thanks,

Tim

Answer 3

Tina,

Here is the information you requested.

1. Screenshots:

a. A screenshot of your sample data in Michigan.

b. An image of the desired result. Please add some comment about the desired result on the screenshot you have already provided.

 this without the great lake portion covered by the county data.

Same map but without the lakes covered similar to this (without the roads, etc.)

2. Detailed steps and related screenshots about how you create the Map.

Select data ----> Insert ----> Maps ---->filled maps

Result = 

3. Your operating system version and Office version.

Windows

For Office version, you can find it by clicking File > Account > Product Information. Please capture a screenshot of the entire information under Product Information. 

Answer 4

Hi David,

Regarding the maps in the workbook, have you checked the information above? Could you please provide the information mentioned above so that we can better assist you?

Thanks,

Tina

Answer 5

Hi David,

To better assist you, we would like to collect more information about the situation. Could you please provide the below information?

1. Screenshots:

a. A screenshot of your sample data in Michigan.

b. An image of the desired result. Please add some comment about the desried result on the screenshot you have already provided.

2. Detailed steps and related screenshots about how you create the Map.
3. Your operating system version and Office version.

Windows

For Windows OS version, press Windows key + S to search for About your PC and share with us its screenshot.

For Office version, you can find it by clicking File > Account > Product Information. Please capture a screenshot of the entire information under Product Information. And please mask your Personal Identifiable Information.

Mac

For Mac OS version, from the Apple menu, choose About This Mac. The version number appears beneath “macOS” or “OS X.”

For Excel version, choose Excel in the top menu bar > About Microsoft Excel and please capture a screenshot of the window. And please mask your Personal Identifiable Information.

Thanks,

Tina