map

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

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

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

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

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!

Hi everyone, I am trying to create map visual in Power BI. My data consists of a list of contacts, their nationlity, and a measure for an average amount. I can create a map visual with a color scale according to the average amount, but I would like to exclude natonalities for which less than...

Hey there! I'm looking to migrate one of my 2D map charts into the new(ish) 3D Maps. It's a veeeeery standard territory map of the USA, so I'm using the Region type map. Now, here's the odd part: while you can enable "Map Labels" (main toolbar on the Home ribbon), that only adds the Bing maps...

Hello, I understand Excel 2019 has a mapping suite built in, where you can mark maps with postcodes etc. At the moment I have some 1,000 postcodes which I have marked on Google Maps with little pins, these are colour-coded according to strength (for example, if 900 records are in the postcode...

I might be asking to much for excel to do this but is it possible for example i import a picture of a map and i was it to mark on the map locations with dots. so in the cell i'm typing the street name erie st. it marks with a dot or what ever on the map. i'm assuming i will have to program it...

Hi all, I've done a fair amount of searching and trying different methods myself; however, I am unable to map a drive letter to a local folder on my machine. This thread shows how to map to a network drive, and it works well for actual network locations...

Hola, Tengo una hoja de excel con los datos de mi país (República Dominicana) y no muestra algunas provincias, cuando consulto el mapa de bing de donde asumo que toma los datos veo lo que asumo es la causa del error, esas dos provincias Bing las marca en el limite y por tanto en excel map marca...

I have created a following Schema in Dreamweaver to import multiple player name in cricket scoring software. <?xml version="1.0" encoding="ISO-8859-1"?> <CricketModel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNameSpaceSchemaLocation="TCS_Players.xsd" version="11.0.11.00">...

I have a spreadsheet with 20 charts, each comparing one of our products vs similar products from our competitors, as well as a map for each competitor. The charts run along the right side of the spreadsheet with the map on the left side. A drop down menu allows you to toggle between maps. The...

Hello, Need some help trying to figure out why when I create a heat map from different timeframes that I'm only getting ":00" and ":30" and not 8:00am, 8:30am, 9:00am, 9:30am...etc. I'm using the formula =FLOOR(N2,"0:30") to round the timeframe to the half hour. I'm sure using "0:30" is...

Is there a way to have a heat map applied to a fixed data set adjust based on a variable? The variable would essentially identify a cell on the data set and the heat map would emanate from that cell instead of from a high-to-low or some other spread. For example, if you have 1-10 on the x-axis...

There is MS access database placed on Citrix environment and i'm trying to Map the network drive but getting error message. Path = \\abcd365.sharepoint.com@SSL\DavWWWRoot\sites\CommunicationDev\test_tree\test\test1 I'm using the below code to map it....but getting error message. Set objNet =...

Morning, here's something for you. I wasn't able to find solution to my question anywhere. However if this topic has appeared somewhere here already, please let me know where I can find my answers. I've got 2 Excel sheets with linked information on both tabs. First one is a table containing a...

Okay, so correct me if I'm wrong, but the purpose of the Worksheet_Change function is to run your code and update each time something is changed in the actual Excel sheet, right? I am having trouble using the Worksheet_Change method in my VBA program. Photos here of my code and then of my...

Hello, I am trying to create a heat map of the facility I work in. Currently, I have conditional formatting set to darken cell color as each microbial instance is input into the worksheet at each location, but I would like to transfer this to points (like, literal circular spots) on a...

Hi Having seen how bad/slow some spreadsheets have been allowed to get, I'm really keen to try and do everything efficiently from the start even before it gets big. So I've done some googling on efficiency of formulas and I've got a few questions I wondered if an expert could help with...