Generate a Dot Density Map

If you’re looking for a map that shows spatial patterns, then our Dot Density Map is the answer! A dot density map presents the differences of location density distributed geographically across a landscape. It’s not only easy to understand but with Mapline, it is also easy to create.

Dot Density Mapping

Steps in Creating a Dot Density Map:

  1. Open your map.
  2. Click the dropdown button on the left sidebar.
  3. Choose “Dot Density” option.
  4. Select your preferred dot color, transparency, and size.
  5. Click the small checkbox if you want the markers to show on your map. If you don’t want the markers to appear, the checkbox is checked by default.
  6. Click the “Save” button.

That’s all it takes to create a dot density map and visualize patterns in your data! Sign up to try it out yourself.

Continue Reading

Custom Territory Mapping with Mapline

Mapline offers a lot of fantastic features to help you analyze your Excel location data. One of these features is territories. With Mapline, you have the option to use a multitude of existing territories as well as creating custom shapes on your map. Want to understand the advantages of each of these methods? We’ve got you covered.

Available Existing Territories – How to Use Territory Mapping Software

Mapline offers territories for dozens of countries, from Afghanistan to Zimbabwe and everything in between. You’re able to select your chosen country or continent and narrow down from that level. Examples of existing territories include: Australian local government areas, postal codes, states and territories and suburbs; China provinces; UK counties, countries, postcode areas, postcode districts and regions; and US zip codes, Census tract maps, congressional districts, area codes and school districts. Find a full list of Mapline’s available territories here.

As you can see, territories vary widely. Using our existing territories is best when you want to analyze your company’s location data in relation to your customers’ own lives and reality. For example, if you want to understand demographic factors associated with customers, you might plot customer addresses and overlay a territory as broad as states or as granular as US Census tracts to view distinct groups of populations and analyze their behavior.

Draw on a Map for Custom Map Making

If, however, you wish to analyze data based on your company’s own indicators, you can use our custom territory mapping to draw a circle on a map (or square or other shape – including irregular shapes) to represent your internal boundaries or delineated sales territories. You’re also able to click on your shape to then see a list of all the addresses located within the shape.

This feature is especially helpful for analyzing sales territories to determine reps’ workload and distribution of both clients and sales personnel.

And there you have it – when to use existing territories and when it’s best to draw on a map to create your own custom shapes. It’s that simple! Want to know what else you can do with Mapline? Browse our features.

Continue Reading

Using the Excel Add-In

Downloading the Excel Add-in

Mapline has an add-in for Excel that makes it even easier to create powerful maps. The only requirement to download it is to be a paying user. To starting using the add-in, follow these steps:

  1. Go to the Excel Add-in page to download the add-in.
  2. Follow the steps in the light-box that appears.

Once you’ve downloaded the add-in, you’re ready to start building and updating maps and data sets in Excel. You have three different options available through the add-in: Upload, Replace, and Download.

Upload a data set directly from Excel

Mapline has made it so easy to upload data that you don’t even need to copy and paste your data to create a data set! You can do it all from Excel by following these steps:

  1. Open a spreadsheet in Excel.
  2. Select the data you want to upload and include the headers.
  3. Click the “Mapline” option in your Excel ribbon.
  4. Select the “Upload” option.
  5. Follow the steps in the light-box that appears.

Replace your data set from Excel

If you’re data set is constantly getting updated, then you can replace your old data from Excel with the newest version to always have up-to-date data on your maps. The replace option will delete the old version of your data set, and you won’t be able to retrieve it from Mapline. So be sure that you have a copy on your computer if you don’t want to lose the data. To replace your data set:

  1. Open a spreadsheet in Excel.
  2. Select the data you want to upload and include the headers.
  3. Click the “Mapline” option in your Excel ribbon.
  4. Select the “Replace” option. (Reminder: This will delete the old version of your data set, and you won’t be able to retrieve it.)
  5. Follow the steps in the light-box that appears.

Download your data set from Mapline directly to Excel

If you make changes to your data set within Mapline, then you can download that data set using the add-in. This will allow you to always have the current version of your spreadsheets on your computer. To download a spreadsheet using the Excel add-in:

  1. Open Excel.
  2. Click the “Mapline” option in your Excel ribbon.
  3. Select the “Download” option.
  4. Follow the steps in the light-box that appears.

Continue Reading

Excel Map Add-In

How to Access Mapline’s Excel Map Add-In

Jumping between applications can be a headache. Fortunately, Mapline provides an Excel map add-in! You can update your maps and data sets without ever having to leave Excel. All you need to do is download the add-in and you’re good to go. As you make your changes, you’re just a couple of clicks away from an updated map. Think of all the time you save by updating everything from Excel with just a few clicks!

With Mapline’s Excel Add-In, you can’t beat all that back and forth:

  1. You will need the Microsoft .NET Runtime and the Microsoft Office Runtime. If you are unsure whether you have these or not, then just proceed with installing the add-in. You will get an error message if these are not already installed on your computer.
  2. Download and install the Excel Add-In for Windows.
  3. Open a spreadsheet in Excel.
  4. Click on the “Mapline” tab on your Excel Ribbon.
  5. Select the function (Upload, Replace, or Download) you want to perform.
  6. Follow the steps in the lightbox that appears.
  7. Check out our instructions for using the Excel Add-in to see everything you can do directly from Excel.

Find out just how easy it is to create a map in Excel with Mapline.

Continue Reading

Export Printable Maps

Export map images right from Mapline! With a few clicks, you can export images the size of your screen or even blow them up to 4 times the size of your screen for enlarged printing. There are three image sizes:

  • Regular – Creates a map that is the size of your screen.
  • Large – Creates a map that is double the size of your screen.
  • Extra Large – Creates a map that is four times the size of your screen.

Naturally, the higher the zoom level the more detailed the map will be. Meaning the Extra Large map will be the most detailed map, but will also be a much larger image than the other two. To see exactly how the map would look printed, make sure to view the downloaded image at the 100% zoom level.

Export Printable Maps

Steps to Export a Map:

  1. Open your map in Mapline
  2. Click on Menu
  3. Click on Export
  4. Select what you want to export (Map or Sidebar)
  5. Select the image size you want

Sign up to start printing maps to use as handouts, for the wall in your office, or anything else!

Continue Reading