Map Chart in Excel 365 does not identify himachal pradesh state in India
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. States Number Puducherry 1 Lakshadweep 2 Andaman and Nicobar 3 West Bengal 4 Orissa 5 Bihar 6 Sikkim 7 Chhattisgarh 8 Tamil Nadu 9 Madhya Pradesh 10 Gujarat 11 Goa 12 Nagaland 13 Manipur 14 Arunachal Pradesh 15 Mizoram 16 Tripura 17 Daman and Diu 18 Delhi 19 Haryana 20 Chandigarh 21 Himachal Pradesh 22 Jammu and Kashmir 23 Kerala 24 Karnataka 25 Dadra and Nagar Haveli 26 Maharashtra 27 Assam 28 Andhra Pradesh 29 Meghalaya 30 Punjab 31 Rajasthan 32 Uttar Pradesh 33 Uttarakhand 34 Jharkhand 35 Telangana 36 I have added the file for reference too Thanks in advance :)