map in excel

Hi, I've created 5 drowndown lists, in columns A to E. The possible options of each list is based off of the selection of the list to it's left. I used data validation =INDIRECT(SUBSTITUTE(D2," ","")) to make this work. What I'm trying to achieve is for column F to give me a certain GL that...

Hello, it is nice to meet everyone (I've been lurking for a while!). I have currently been playing around with Excel's fancy 3D Map feature. I currently have a set of data that gives me postcode/location, amount/height, start date, and end date. I am able to get 3D map work to the point where...

Hello, I have a set of data that's split by town/city (in the UK) and the sales numbers associated with the town/city. Is there a way I can put a bubble chart on a map for visualisation. Example below: London - 5300 Manchester - 2750 Birmingham - 7862 Newcastle - 8000 As logic would dictate...

Hello, I have adapted the map by Jordan Goldmeier to my own work, but I cannot figure out how to adapt and use the user-defined function to get shape's properties. I had to use a less convenient macro for this. Could someone please explain in more detail how this user-defined function works...

I created a map with 3 d Map Montreal's uiing open data for 311 calls, I selected a subset for calls regarding calls for rat extermination. The data has geo location for each call. I then tried to amend the tour to a regional map with electorial district by importing a kml file that was also...

Morning all, I'm playing around with the Map graphing abilities of Excel within my Office365 subscription. I've managed to get it to plot some data for major European countries but not for towns local to my area in Cumbria, UK. Do I need an add-on? Anyway. An example of the (made up) data I'm...

This thread is regarding how format a color on a cell in a map of a building I drew in excel. In my map, each square foot in the facility corresponded to a cell in excel. For instance, the spot right by a door in the building might be "FA 130," where FA indicates the column and "130"...

Hi All, I've got a big table of data and within it I've used 'post code' to plot points on a map using PowerView. These locations were visited in order and it would be very useful to see in what order they were visited - preferably by connecting them with a line (either as the crow flies...

Team, Andy Pope created a fantastic USA Interactive Map application (AJP Excel Information) which will allow users to color the states (each state resembled with an object) according to a data value in the range 0 to 9. Based on Andy's map, I am building a dashboard to show revenues by state...

Hi all, My question is.... How to capture the value in the cell within column B instead of B11 cell only? For example, user can select any address in column B cell in order to search location at Google Maps...

Hi, I have hunders of x and y coordinate points and I had to plot them in excel. I have plotted these points using the X and Y scatter option without a problem. I am now trying to upload a background map, so user can visually see the location of the each point. I have the screen shot...