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
Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies