Skip to content
Facebook page opens in new windowLinkedin page opens in new windowYouTube page opens in new windowRss page opens in new window
Cart0

View CartCheckout

  • No products in the cart.

Subtotal: 0.00 €

View CartCheckout

Login
Maps for Excel – Simple Excel Add-In to create filled maps & dashboards in Excel
Excel Map, Filled Map, Choropleth Map, Build Regions, Post Codes, Bubble Chart on Maps, Power BI
Maps for Excel - Simple Excel Add-In to create filled maps & dashboards in ExcelMaps for Excel - Simple Excel Add-In to create filled maps & dashboards in Excel
+48 500 196 861
contact@maps-for-excel.com
  •  
  • Products
    • Demo
    • Credentials
  • Free Mapping Video Course
  • Trainings
    • Art of Data Visualization & Dashboard Design
    • Excel BI for Analysts
    • Data visualisation and designing dashboards in Tableau
    • Power BI – create data model, design dashboard, share report
    • Certification
  • Services
    • Excel Maps, Geoanalysis, GIS System
    • Excel reports automation & design with VBA, Query & PowerPivot
    • Power BI & Business Intelligence
    • Reports, Analyzes & Infographics
    • Credentials
  • Blog
    • Newsletter
    • Resources
  • About Me
  • Contact
Search:
Search
  •  
  • Products
    • Demo
    • Credentials
  • Free Mapping Video Course
  • Trainings
    • Art of Data Visualization & Dashboard Design
    • Excel BI for Analysts
    • Data visualisation and designing dashboards in Tableau
    • Power BI – create data model, design dashboard, share report
    • Certification
  • Services
    • Excel Maps, Geoanalysis, GIS System
    • Excel reports automation & design with VBA, Query & PowerPivot
    • Power BI & Business Intelligence
    • Reports, Analyzes & Infographics
    • Credentials
  • Blog
    • Newsletter
    • Resources
  • About Me
  • Contact

Monthly Archives: June 2017

You are here:
  1. Home
  2. 2017
  3. June

How to design a flow map for logistics with Excel Map?

Excel Map TutorialBy BartekJune 16, 20173 Comments

If you are trying to analyze what is going on in your logistics, you might need the flow map that will show where your distribution centers are and where you send your products to. With Excel Map it’s really easy to customize a map like this to show with arrows the direction of your flow.

How to change the bubble shape into a logo?

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

Sometimes you may want to attract the audience with a non-standard map. One of the ways to do it is to use a graphic instead of clean data visualization like bubbles. With Excel Map you can easily replace the bubble shape with an image.

How to geocode customer addresses and show them on an Excel bubble chart?

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

If your data contains addresses (or just part of it like city or post code) you can try to show the data on the map. Although Excel Map does not support zoom in like Google Maps or any other Internet map do, it can give you an overview on where your addresses are (e.g. of…

2 ways to filter the bubble chart on Excel Map

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

There are two ways to create a quick filter for the bubble chart layer in the Excel Map: if you are Excel 2013+ user, you can create a slicer or you can create a non-standard filter based on your list.

How to show 2 measures on the map?

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

What is the problem with the filled map? You can show only 1 measure on a map at the same time. What if you would like to show two of your KPIs: the size of the sales and the target realization? Use colored bubble chart.

How to compare consequtive years on the map?

TablesBy BartekJune 16, 2017Leave a comment

What is the best way to quickly compare your results on a map between consecutive years? Check the Choose data range option that allows you the quickly switch between various options.

How to enlarge detailed parts of the map? Example for Excel Map France

TablesBy BartekJune 16, 2017Leave a comment

What if your map has parts that are very detailed? No problem. You can use a great built-in Excel functionality called Paste as Linked Picture. Just copy & paste cells behind the shapes and edit the picture.

How to drill down on Excel Map France?

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

If the map has two administrative levels (like Excel Map France, where there are Regions and Departments) you can easily drill down and up between these levels using Hide shapes functionality. The example will be based on the population data for France.

How to classify your data on a filled map (choropleth map)? Population on Excel Map France

Excel Map TutorialBy BartekJune 16, 2017Leave a comment

The most important decision to be made when designing a filled map (professionally called a choropleth map) is to define colors classes. As the designer, you decide which value goes to which color. Your decision will have a great impact on what the audience will get from your map. Get to know 3 ways to…

How to change the shape labels? – Example for Excel Map France

TablesBy BartekJune 16, 2017Leave a comment

The default label in Excel Map, that is shown after clicking the shape (or a point on bubble chart), shows the name of the area, its parent (if there is any) and the value that can be found in the column G of Data sheet. How to edit this label?

→12→
© Copyright SkuteczneRaporty.pl 2010-2020
  • Terms and conditions
  • Demo
  • Privacy Policy
MENU BOTTOM

Made with by FunkyBike.ART Creative Agency

Go to Top