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
Established 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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies