Forum Discussion
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 :)
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
Hi,
Type "Himachal Province" it will recognize HarshidSridhar
