map

  1. G

    Address spreadsheet to maps

    I have a list of addresses 100ish. Is there a way to vba from Excel to map out a route to follow in Google maps, Waze, Bing maps, it any other option.
  2. F

    How do I make the color gradient of my surface chart to match my "heat map"?

    Here is my surface chart https://imgur.com/a/DKZnEtO and the colors clearly does not match those in my heat map https://imgur.com/a/imbr5dV. How can I fix this?
  3. F

    How do I make the color gradient of my surface chart to match my "heat map"?

    I have this "heat" map here and this surface graph here how do i make the gradient on my surface graph to match the heat map dynamically?
  4. B

    Run-Time error '1004' Method 'SaveAs' of object'_Wokkbook' failed

    Hello, I'm trying to save a newly created file in csv format. I am copying results from one open file, and pasting in a new workbook, and then trying to save the new workbook as a csv file. My code is below. See the "Save File as CSV" section below. Thanks! Sub Monthly_Device_Volume_Map()...
  5. T

    Multiple Routes on Single Map

    Good Afternoon, I know this isn't an Excel question, but I was hoping someone on this board could help. I need to create mutiple routes on a map and was wondering if anyone new of a free service to do this task. Basically ill have 41 distinct across the US and the software my company uses you...
  6. T

    Multiple rows Map to Multiple rows

    Hi this is my first post, firat of all thank you to eveyone here this site is always a great source of infiormation and help. :) Here is my problem I have a list of People and a list of items, each item has to aligned to the person - Multiple persons - Unique Item Thanks in advance...
  7. M

    VLOOKUP - Return Blank

    Trying to get the results that I need If the value searched on (A2 of "Worksheet A") is found in A1:M30 of "Worksheet B" Then map the according value that exists in column M (column 13) But if the cell in column M is blank, map blank instead of "0"
  8. M

    Opening a KML file into an Excel Data Map

    I am able to open a KML file in Google Earth and Google Earth will provide me a map of boundaries for geographical entities, like counties. Is there a way I can open a KML file in an Excel Map?
  9. H

    Excel Maps

    Evening all, I hope you can help. I am trying to enter details for a region of South England, United Kingdom and pull this information in to a map using Excel Maps. However I can only get the map to show England, Scotland, etc and not the counties. I am trying to add A1 - Reading A2 - Swindon...
  10. S

    Plotting Latitude and Longitude onto a map in excel

    Good Morning I have been scouring the tinterweb for a while now looking for a post which may offer me the right guidance, but to no avail. I have an excel workbook which holds a database of latitudes and longitudes around the world. I am trying to figure out if there is a way to have these...
  11. E

    Excel 2016 Map Charts

    Hi.I have recently got Excel 2016 and am discovering so many awesome new things. I have managed to made a Map Chart of Australia and all the data from my table is working perfectly. I do have a problem though. We have a very small territory (Australian Capital Territory or ACT) which shows on...
  12. M

    Creation of Saudi Arabia Population Map

    Hello, Can someone help me on how to create a MAP in excel on Saudi Arabia and put in the necessary population by region/area. Is there a way of doing this on Excel 2016. Regards
  13. B

    Remove the first word of every sentence in a cell

    Hello, For the sentence: "A map is a visual representation . The work of a map is to illustrate geography." I know that the formula "=RIGHT(B2,LEN(B2)-FIND(" ",B2))" will remove the first letter in the string. Leaving "map is a visual representation . The work of a map is to illustrate...
  14. S

    Heat Map Add In for use in the UK

    Hi All I have just discovered this add in app - very excited, but confused. In need to create a heat map of data relating to wards/postcodes within a UK local authority; I understand the concept, but has anyone else managed to do this successfully using this app in Excel? If so maybe we...
  15. H

    VBA to map cells

    Hi all, Brand new to this board and also to VBA so please forgive any uselessness on my part. Looking forward to learning loads. I am trying to use VBA to map cells. I'd like to click on the destination cell and then select the source cell (that contains the data) and have that data copied to...
  16. W

    How to link cells together?

    So in my spreadsheet, column A is populated with three digit numbers down to row 100. These numbers are from specific areas on a map im working on. The area numbers are going to be temporarily changed, so coloumn B is populated with the new area numbers, for the new map. Essectially, I want to...
  17. E

    Form + overview

    Hello We are building a mini database of all the claims we file with our carriers. The idea is that we fill in all the details in one tab called 'details' (the standard form that we can copy/paste from other spreadsheets also). Once completed, we run a macro after pressing a button or some...
  18. E

    3D Map

    I am looking for sample statistical data for a school project for creating a 3D Map using Excel's 2016 feature. I have research multiple websites, for example, crime in 2018 in the US. To create the 3D Map it requires the state, or country in the data in order to map it. Can you recommend...
  19. N

    Office Excel 365 - Insert Map - No Southern Ireland?

    Hi All, I have a list of values and locations. I then go to insert, then map graph. A map appears and plots well, but the southern Ireland bit of the map is missing. I've tried changing it to towns, cities etc, but southern ireland is blanked out. Does anyone know why or how I could get...
  20. A

    Excel Map Data Label Question

    Hi All, I've got an Excel Map of the US and the data labels appear in the middle of each state. Is there a way to move the data labels for the smaller states? They seem to be locked in their position. Thanks!

Some videos you may like

This Week's Hot Topics

Top