Chart displayed as Map of Montana

E

esgca2010

New Member
Joined
Jul 29, 2010
Messages
40
First thank you for your continued support. I have made all efforts and can't get it to work.

I’m hoping you can help me recreate a population density map of Montana. I would love to do one by county and then by for reservations! Numbers represent for 2023.

Thank you all so much for your support. Of course, I have a deadline for this map.

Elaine
 

Attachments

  • ScreenshotOfMontanaStats.png
    ScreenshotOfMontanaStats.png
    18.9 KB · Views: 6
  • ReducedMontanaMap.png
    ReducedMontanaMap.png
    56.3 KB · Views: 6

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
What would be the problem you are having? the image of the map is very small.
 
Upvote 0
If your problem is that for some counties the data is not shown on the map, try adding a column with the state. I ran some tests and it works fine like this:

StateCountyPopulation
MontanaBeaverhead County9,885
MontanaBig Horn County12,751
MontanaBlaine County6,899
MontanaBroadwater County8,032
MontanaCarbon County11,419
MontanaCarter County1,418
MontanaCascade County84,900
MontanaChouteau County5,847
MontanaCuster County11,985
MontanaDaniels County1,633
MontanaDawson County8,810
MontanaDeer Lodge County9,673
MontanaFallon County2,994
MontanaFergus County11,772
MontanaFlathead County113,679
MontanaGallatin County126,409
MontanaGarfield County1,211
MontanaGlacier County13,609
MontanaGolden Valley County835
MontanaGranite County3,595
MontanaHill County16,276
MontanaJefferson County13,048
MontanaJudith Basin County2,093
MontanaLake County33,338
MontanaLewis and Clark County75,011
MontanaLiberty County1,974
MontanaLincoln County21,895
MontanaMadison County9,521
MontanaMcCone County1,676
MontanaMeagher County2,071
MontanaMineral County5,090
MontanaMissoula County121,849
MontanaMusselshell County5,308
MontanaPark County17,903
MontanaPetroleum County554
MontanaPhillips County4,249
MontanaPondera County6,125
MontanaPowder River County1,743
MontanaPowell County7,133
MontanaPrairie County1,112
MontanaRavalli County47,738
MontanaRichland County11,173
MontanaRoosevelt County10,319
MontanaRosebud County8,160
MontanaSanders County13,684
MontanaSheridan County3,498
MontanaSilver Bow County36,360
MontanaStillwater County9,173
MontanaSweet Grass County3,763
MontanaTeton County6,430
MontanaToole County5,133
MontanaTreasure County772
MontanaValley County7,474
MontanaWheatland County2,057
MontanaWibaux County910
MontanaYellowstone County170,843


1723480705996.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question Question
PivotTable Calculated Field
Replies
5
Views
91
Domenic
D
A
  • Question Question
Guidance Needed: Efficient Data Collection and Liquid Stock Tracking in Excel
Replies
0
Views
121
Azzam
A
S
  • Solved
Gloss Colours in A Stacked Bar Chart
Replies
2
Views
95
SteveP29
S
R
  • Question Question
Auto populating a map with numbers
Replies
1
Views
463
RodneyW
R
J
  • Question Question
Excel Map Chart
Replies
1
Views
357
kevin9999
K

Forum statistics

Threads
1,223,214
Messages
6,170,774
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top