Excel India Map with no Labels

Excel India Map with no Labels

Use following steps to create an Excel India Map with no Labels for your KPI-Dashboard or Management-Reporting.

Excel India Map with no Labels, Excel India Map no captions, points (Administration Level 2: Districts)

Excel India Map (Asia) with no labels, captions, points (Administration Level 2: Districts)

 

Start or Open the Excel-Addin Inda Map with the corresponding Administration Level (States / Union Territories or District Map). Remember Andhra Pradesh was divided into two states, Telangana and a residual Andhra Pradesh on 2 June 2014. For individual Solutions, please contact your maps4office team.

In order to use all the functions of Addin-Map in Excel, you need to activate the macro functions in Microsoft MS Excel (or PowerPoint). A Short tutorial to enable or activating macros for MS Office – you will find on: Enable macros for MS Office.

If you now your administration name (e.g. from your CRM-System, Qlikview, MS Navision or other BI-System), you can promptly select your data range and import all data into the India-map-wizard.

 

If you want to create a completely new Excel India Map with no labels or captions – klick on the Ribbon “List”. The Excel-Addin create a new Sheet with Administration-ID, Administration Name and/or Postcode Areas. On the next column, you can enter your own Values.

Starting the Wizard India-Map (Menu-Item: Generate).

xls map India Map Excel districts india with no labels, captions, own free text range

Wizard: Excel India Map – setting options for no labels, captions and other items

 

And enable in the Setting Option “Display add Elements” the checkbox “Free text” and “area names”. It can be useful to unable also the “radio-button” for “no illustration” (e.g. harveyballs or circles) or view no values.

 

If you use the Map for business presentations or reporting, use in the ribbon (Menu-Item) the Export Button to PowerPoint. The Wizard create a new PowerPoint Presentation and export all shapes and labels into your slides. If you delete some shape in Excel, this deleted shape will not appear in the current presentation. Now, in PowerPoint you are free to rename or add addition information into your India Map.

excel addin india map states use selection pane to delete items for powerpoint export

excel addin india map (states: administration level 1) use selection pane to delete items for powerpoint export

Preview India Map for Districts (Excel-addin)

Excel india map districts with no labels, coloring, labeling by xls cells, values and range