Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-689806%22%20slang%3D%22en-US%22%3EMap%20Chart%20in%20Excel%20365%20does%20not%20identify%20himachal%20pradesh%20state%20in%20India%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689806%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20build%20a%20series%20of%20heat%20maps%20for%20India%20providing%20some%20state%20level%20insights.%26nbsp%3B%20When%20attempting%20to%20build%20a%20map%20chart%2C%20I%20realised%20that%20the%20chart%20doesnot%20identify%20Himachal%20Pradesh.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20someone%20please%20help%20me%20with%20this%20%3F%20I%20used%20the%20following%20test%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EStates%3C%2FTD%3E%3CTD%3ENumber%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EPuducherry%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELakshadweep%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAndaman%20and%20Nicobar%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EWest%20Bengal%3C%2FTD%3E%3CTD%3E4%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EOrissa%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EBihar%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ESikkim%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EChhattisgarh%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETamil%20Nadu%3C%2FTD%3E%3CTD%3E9%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMadhya%20Pradesh%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EGujarat%3C%2FTD%3E%3CTD%3E11%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EGoa%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENagaland%3C%2FTD%3E%3CTD%3E13%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EManipur%3C%2FTD%3E%3CTD%3E14%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArunachal%20Pradesh%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMizoram%3C%2FTD%3E%3CTD%3E16%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETripura%3C%2FTD%3E%3CTD%3E17%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDaman%20and%20Diu%3C%2FTD%3E%3CTD%3E18%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDelhi%3C%2FTD%3E%3CTD%3E19%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHaryana%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EChandigarh%3C%2FTD%3E%3CTD%3E21%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHimachal%20Pradesh%3C%2FTD%3E%3CTD%3E22%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJammu%20and%20Kashmir%3C%2FTD%3E%3CTD%3E23%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKerala%3C%2FTD%3E%3CTD%3E24%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EKarnataka%3C%2FTD%3E%3CTD%3E25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EDadra%20and%20Nagar%20Haveli%3C%2FTD%3E%3CTD%3E26%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMaharashtra%3C%2FTD%3E%3CTD%3E27%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAssam%3C%2FTD%3E%3CTD%3E28%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EAndhra%20Pradesh%3C%2FTD%3E%3CTD%3E29%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EMeghalaya%3C%2FTD%3E%3CTD%3E30%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EPunjab%3C%2FTD%3E%3CTD%3E31%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ERajasthan%3C%2FTD%3E%3CTD%3E32%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EUttar%20Pradesh%3C%2FTD%3E%3CTD%3E33%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EUttarakhand%3C%2FTD%3E%3CTD%3E34%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EJharkhand%3C%2FTD%3E%3CTD%3E35%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ETelangana%3C%2FTD%3E%3CTD%3E36%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20added%20the%20file%20for%20reference%20too%3C%2FP%3E%3CP%3EThanks%20in%20advance%20%3A)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-689806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMap%20Chart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
HarshidSridhar
Senior Member

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 :) 

Related Conversations
Weekly rotating list
Rashy_wearer2 in Excel on
0 Replies
Formula to calculate between "Closing Balances"
calof1 in Excel on
2 Replies
Userform-Transferred Data must not be editable
Mr_Buttons in Excel on
0 Replies
need urgent help for excel
talikne610 in Excel on
2 Replies
Excel no longer capable of Relative links
GoodallS in Excel on
0 Replies
Grouping by dates in Excel?
MMH11 in Excel on
1 Replies