Map Chart in Excel 365 does not identify himachal pradesh state in India

Copper Contributor

I am trying to build a series of heat maps for India providing some state level insights.  When attempting to build a map chart, I realised that the chart doesnot identify Himachal Pradesh. 

 

Could someone please help me with this ? I used the following test data. 

 

StatesNumber
Puducherry1
Lakshadweep2
Andaman and Nicobar3
West Bengal4
Orissa5
Bihar6
Sikkim7
Chhattisgarh8
Tamil Nadu9
Madhya Pradesh10
Gujarat11
Goa12
Nagaland13
Manipur14
Arunachal Pradesh15
Mizoram16
Tripura17
Daman and Diu18
Delhi19
Haryana20
Chandigarh21
Himachal Pradesh22
Jammu and Kashmir23
Kerala24
Karnataka25
Dadra and Nagar Haveli26
Maharashtra27
Assam28
Andhra Pradesh29
Meghalaya30
Punjab31
Rajasthan32
Uttar Pradesh33
Uttarakhand34
Jharkhand35
Telangana36

 

I have added the file for reference too

Thanks in advance :) 

3 Replies

Hi,

Type "Himachal Province" it will recognize @HarshidSridhar 

@HarshidSridhar 

Yes - while I can get Himachal Pradesh to show but none of the cities into it including Shimla!

It works for all cities of Punjab, J&K, Uttarakhand, etc.

Is Microsoft even aware of this?

@v22arvind Still Lakshadweep is not mapped here, can you please help