Select the “Geography” of the Custom Map, which will be the X and Y Coordinate System in the Layer Pane on the right. Now that the data mapping is complete, boot Power Map and select New Scene > New Custom Map.
This is simple enough to do by opening Microsoft Paint, hovering over a city with the mouse, and recording its pixel position in the bottom-left hand corner of Paint into X and Y columns in Microsoft Excel. In our case, we want to show the total number of passengers on the cities, so we need the pixel position of each city.
One such mapping is the pixel placement of where you want your data to appear. Power Map needs a way to plot your data on an X, Y coordinate system. For this example, we have the number of passengers on the train routes at given intervals throughout the day.ģ. Next, it’s assumed you have some data which relates to the image. Here’s is the one that we used for this example:Ģ. In this case, we have a map of the island with various cities and paths of trains plotted. First, you will need an image: any jpg, bmp, or png file. To illustrate the process from start to finish, we’ll walk through the creation of a Custom Map that visualizes train routes on the imaginary island of Lunda.ġ. All you need is (1) an image with your custom map and (2) data that you can map in an XY coordinate system/plane.
#Create a custom map how to#
In this post I’ll show you the basic steps for how to create a custom map with Excel Power Map. You can get enhanced versions of these features as part of Power BI for Office 365, our cloud-based solution for analyzing, visualizing and sharing data insights across your company or organization.
#Create a custom map professional#
Power Map is part of several analytics and visualization features, such as Power View, that comes with Excel when you get an Office 365 subscription with Office Professional Plus. In early September, we introduced you to Custom Maps, a new feature in Power Map for Excel. If you experience any issues, just refresh the page or click 'Clear the Map'.This blog post was authored by James Marshall, Developer on the Excel Power Map team
#Create a custom map pdf#
Most computers already have one, but you will need a PDF viewer/reader such as Adobe Reader to view the results. If you choose a background feature, it will overlay on the background image you select. A blank background uses less ink if you're printing, but doesn't look as much like a treasure map. Tap or click the image to change the background or background feature.
The path won't show on the website, only on the PDF. Use the drop down in any section to have the path stop in that section on the final PDF. The path is a dotted line you might image on a treasure map. On the PDF, text will be displayed under an image if an image is chosen, or will be vertically centered in the middle of the section if an image isn't chosen. You may optionally add text to any map section or create a path to traverse your map. There's four columns and four rows of sections. It will eventually cycle through to a blank image. Tap or click each the text in each section to change the image on that portion of the map.
0 kommentar(er)
