Share via

Getting error while doing Choropleth Map

Anonymous
2024-02-01T03:13:11+00:00

When creating a choropleth map using EXcel, I am getting the following error We plotted the X% of the locations from your county with high confidence. It is not drawing the map. I am drawing map for County and Beef Cattle head column

Data file is;

State County Beef Cattle (head) Area (sq. mi.)
Nebraska Adams 24,598 563
Nebraska Antelope 28,000 857
Nebraska Arthur 18,834 715
Nebraska Banner 14,500 746
Nebraska Blaine 21,500 711
Nebraska Boone 17,100 687
Nebraska Box Butte 21,000 1,075
Nebraska Boyd 24,500 540
Nebraska Brown 31,500 1,221
Nebraska Buffalo 21,352 968
Nebraska Burt 6,700 493
Nebraska Butler 7,761 584
Nebraska Cass 5,600 559
Nebraska Cedar 19,600 740
Nebraska Chase 41,476 894
Nebraska Cherry 166,000 5,961
Nebraska Cheyenne 9,200 1,196
Nebraska Clay 8,009 573
Nebraska Colfax 11,100 413
Nebraska Cuming 10,700 572
Nebraska Custer 100,000 2,576
Nebraska Dakota 555 264
Nebraska Dawes 33,000 1,396
Nebraska Dawson 68,434 1,013
Nebraska Deuel 5,900 440
Nebraska Dixon 7,386 476
Nebraska Dodge 9,397 534
Nebraska Douglas 1,400 331
Nebraska Dundy 23,500 920
Nebraska Fillmore 5,788 576
Nebraska Franklin 15,600 576
Nebraska Frontier 26,500 975
Nebraska Furnas 16,191 718
Nebraska Gage 10,200 855
Nebraska Garden County 23,107 1,705
Nebraska Garfield 18,000 570
Nebraska Gosper 16,000 458
Nebraska Grant 23,500 776
Nebraska Greeley 29,500 570
Nebraska Hall 17,330 546
Nebraska Hamilton 4,400 544
Nebraska Harlan 15,100 553
Nebraska Hayes 21,000 713
Nebraska Hitchcock 7,415 710
Nebraska Holt 99,000 2,413
Nebraska Hooker 13,100 721
Nebraska Howard 18,100 570
Nebraska Jefferson 11,200 573
Nebraska Johnson 8,500 376
Nebraska Kearney 30,846 516
Nebraska Keith 17,100 1,061
Nebraska Keya Paha 28,000 773
Nebraska Kimball 9,300 952
Nebraska Knox 52,000 1,108
Nebraska Lancaster 10,400 839
Nebraska Lincoln 69,000 2,564
Nebraska Logan 15,600 571
Nebraska Loup 11,488 570
Nebraska McPherson 23,000 573
Nebraska Madison 12,900 859
Nebraska Merrick 11,369 485
Nebraska Morrill 35,000 1,424
Nebraska Nance 13,800 441
Nebraska Nemaha 4,400 409
Nebraska Nuckolls 12,072 575
Nebraska Otoe 6,185 616
Nebraska Pawnee 10,400 432
Nebraska Perkins 14,300 883
Nebraska Phelps 9,900 540
Nebraska Pierce 20,500 574
Nebraska Platte 14,800 678
Nebraska Polk 11,921 439
Nebraska Red Willow 25,919 717
Nebraska Richardson 9,200 554
Nebraska Rock 37,000 1,008
Nebraska Saline 9,700 575
Nebraska Sarpy 1,898 241
Nebraska Saunders 7,800 754
Nebraska Scotts Bluff 18,000 739
Nebraska Seward 9,400 575
Nebraska Sheridan 56,000 2,441
Nebraska Sherman 26,000 566
Nebraska Sioux 35,000 1,313
Nebraska Stanton 9,397 430
Nebraska Thayer 12,300 575
Nebraska Thomas 15,700 713
Nebraska Thurston 3,400 394
Nebraska Valley 36,106 568
Nebraska Washington 5,600 390
Nebraska Wayne 9,800 444
Nebraska Webster 51,844 575
Nebraska Wheeler 22,500 575
Nebraska York 5,500 576
Microsoft 365 and Office | Excel | For home | MacOS

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 No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2024-02-08T15:40:24+00:00

    Dear subramab

    Good day!

    This could be a problem with the map service, we kindly recommended you can raise a service request in Microsoft 365 admin center, which the support there has the related permission and resource to help you check from the backend

    Thanks for your cooperation.

    Sincerely,

    Tin | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-02-01T15:00:48+00:00

    Hi Tin,

    I had my Microsoft Office Updates automatically and is on up to date. Still I am facing the issue. Please find the excel version details below

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2024-02-01T12:34:18+00:00

    Dear subramab

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    I didn't get the same error in our tests here. Please check whether your Office applications have been up to date with the latest version. You can reference this article:Update Office for Mac automatically - Office Support (microsoft.com).

    If the problem persists, please try running Office by starting up your Mac in safe mode to see the result. This can help us check whether issues you are experiencing are caused by software that loads as your Mac starts up.

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

    Trying the above steps can greatly help us reduce this phenomenon, thank you for understanding that sometimes the initial suggestion may not help you immediately, if you still experience this situation, please inform us of the following information:

    • The version information of Excel you are using

    We look forward to your reply. Thanks for your cooperation.

    Sincerely,

    Tin | Microsoft Community Moderator

    Was this answer helpful?

    0 comments No comments