Filling a US map

[cmyers900]

I am trying to fill the map with the information from the attached and not sure what I am doing wrong?  I have tried Youtube and help on Excel.  Can someone please guide me?

[#2]

@cmyers900 

Same categories shall be in the same columns, please see the last sheet attached.

[#3]

@Sergei Baklan 

Thank you.  Is there a good tutorial I can watch or view to help me with a start to finish process?

[#4 · Accepted solution]

@cmyers900 

Oh, I don't know, sorry. You may start from support articles

https://support.office.com/en-us/article/create-a-map-chart-in-excel-f2cfed55-d622-42cd-8ec9-ec8a358...

https://support.microsoft.com/en-us/office/format-a-map-chart-2c744937-a1cc-48f7-bc5e-776497343a29

[#5]

@Sergei Baklan

My goal is to get it to look like this.  I really appreciate the time and help. 

[#6]

@Sergei Baklan 

Thank you

[#7]

@cmyers900 

Afraid exactly the same won't be possible, only some approximation