Use of Custom Maps

[Yvonne Love]

Hi all,

I actually am assuming there isn't a way to accomplish this, but I thought it wouldn't hurt to ask. In Texas, we have Regions (as seen on the attached map - dark line borders), and I would like to be able to fill the regions as either a heat map or even be able to fill individual regions to the level equivalent of how many clients we have in that region (if there are 100 clients in one region, and we have 75 of them, I'd like the region to be 75% full). I'm not even sure this is possible and it is probably just a pipe dream, but I know Excel is pretty amazing, so I thought I would ask the experts.

Thank you in advance!!
YL

 

[Hui]

That is absolutely achievable

Have a read of:
http://www.tushar-mehta.com/publish_train/xl_vba_cases/0301-dashboard-conditional_shape_colors.htm
https://excelcharts.com/how-to-create-thematic-map-excel/
http://blog.cartong.org/2015/11/20/choropleth-maps-excel/

 

[Yvonne Love]

Thank you @Hui . This is excellent! Both give ways to shade based on a specific range of percentages or values. But I've also been looking to see if there is any way to fill the custom shape partially based on a percentage. Meaning, is there a way to fill the shape only 75% full or 35% full based on a value? I haven't been able to find anything, so it may be possible I am not using the correct word search. Do you know if this is possible?

I have attached my spreadsheet with the custom map for reference. I would like to shade the shapes (all named) with the percentages in column Q.

Thanks again! Even if partial shading isn't an option, I can definitely go by the range.

YL