map

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...

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...

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...

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...

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>...

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?

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.

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...

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...

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...

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...

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...

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?

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...

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...

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...

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...

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.

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...

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...