map

  1. K

    Google Map Integration - HELP!

    Greetings Fellow Excel Nerds, I am working on a project that requires good map integration. The user will have a csv and an accompanying kml file. The desired result is a map displayed on the worksheet with the ability to click on a given record or set of records and display location points...
  2. F

    Creating a map in excel and inputting a number to make a dot appear?

    Hi there, I am using excel 2013 and I am wondering if there is a way to make a dot (location of a building) appear on a picture of a map I inserted into excel if I type a specific number in a cell range. For example: Range A1:A120 would be the numbers for the buildings (A1:1234, A2:1235...
  3. M

    Create Inventory Map - changes weekly

    Good Day, I have been given another task to try and do in Excel that is a little more complicated then before. Currently we write by had a map showing where the Categories and Items are located on about 50 shelves. We try and have our shelves sorted in Categories and Items in those...
  4. W

    Does latitude and longitude fall within area?

    Hello, first time poster. I have a list of zip codes and their corresponding latitude and longitude points from the US census bureau. I was hoping this data could be used to determine if a given zip code fell within a certain radius of another zip code. In other words, if I could take the...
  5. P

    Make Geographic maps Using Excel

    Question 1 The longitudes are across the 1st row. The latitudes are in column A. The values of my dataset are in the intersections of these. How would I create a contour map of this on the earth? <tbody> A B C 1 -80 -70 2 40 5.3 18.6 3 30 17.9 20.2 </tbody>...
  6. B

    Adding a clickable US Map to Excel 2013 Dashboard

    I would like to add a US map to my dashboard of election results. Clicking on a state would lead to charts of results. Any ideas?
  7. H

    Map graph in excel 2010

    Hi, I have data sotmething like TX 28, NY 27, CA 13. I need to plot it on the map of US. How would I able to do it in Excel 2010? Thank you in advance for your any input.
  8. L

    POWER VIEW - does not recognize the addresses - POWER MAP does

    Hi, Please find an example of the table below which I am trying to put in a map in Power view. Power view opens but do not recognize / locate the addresses in the Czech Republic. Funnily enough, using the same table, Power Map is able to locate the address automatically. Power view works as I...
  9. J

    Using Excel To Manage Inventory at a Production Yard Over Time

    Hello, First off I should mention that I am a relatively novice Excel user; I can use IF statements and other formulas or formatting but I have no experience with advanced tools such as Macros. I manage inventory at a manufacturing facility, meaning I coordinate where items are located in our...
  10. adaytay

    Interactive Excel Chart

    Hi all, it's been a while! Had an unusual request in from a client, and thought I'd post up here as it's something I don't even know if is possible. A client has a spreadsheet with a table of data and a chart. Updating two cells with new latitude and longitude co-ords moves the position of an...
  11. G

    Hide all columns that only values of zero

    I have a spreadsheet with a few hundred columns. Each column is a chemical, with the amount of that chemical released in the rows. I need to make this spreadsheet into a map. Right now, when you click on a point on the map, every chemical shows up with the amount of that chemical produced beside...
  12. C

    Sending "Picture Links" behind charts

    Good Day, This has stumped me. I need help layering a bubble chart over a picture (map), but the thing is the picture is linked with a formula that dynamically changes the map displayed based on a selection. When it's a normal picture everything is fine I just use Order>Send to Back on the...
  13. S

    Heat Map in Excel

    I need to create a heat map with a map of USA in excel and have no idea how to do it. I tried using an add-in called begraphic but that does not seem like a sustainable option. Can anyone help me?
  14. H

    exporting row as different file format

    Hello all, I have a question regarding exporting something as a xml (or specifically a KML) file format. I have a series of rows of data which i have imported into excel from KML files. Let's say I have since altered these rows to fit my needs. I imagine this will require a macro command...
  15. A

    Match and combine data in two sheets

    Hi, I would like to combine two sheets/excell files which are as follows. In the first one, I have a list of students with their IDs (column A), names and last names (remaining columns). In the second one, I have the marks obtained by the students in a test mapped to their IDs (column A, student...
  16. D

    How to detect amount of changes in cell?‏

    Hi All, I need a macro which quietly counts changes made to a cell and stores them even after the workbook is closed. If the cell has been modified more then say 5 times in one day it is highlighted yellow more then 10 highlighted red. Then i need week counts and month counts (years maybe...
  17. L

    Thematic map in excel 2007+ help

    Hi, So ive scoured the Internet and forums looking for some help for this. Basically I have many sales people (1000) across the united states and I want to track their sales results visually on a map of the united states if possible. My first attempt was to create a very crude map just...
  18. V

    Map in Excel

    Here is what I want to do, I want data in excel to color a certain section on a map - how would I go about accomplishing this? I am pretty sure I will need to create an image map in order to create the particular coordinates.
  19. Y

    Plotting geographical data on a map

    Hi, I am using Excel 2007 and winXP. I am interested in having a "heat map" using a geographical map. Meaning, I have information for different countries (numerical values, lets say China is 5 and India is 10). I want to plot it on a geographical map such that the country on the map appears...
  20. A

    color a map with excel !! any idea

    i have a world map that each country have a separated picture same this: www.presentationmagazine.com/powerpoint-templates/00402.ppt i want to link every country with a "value" (for example one number between 1 to 100. 100 = black & 0 = white ) in a column. for example if i hyperlink...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top