A step by step walkthrough for turning a sheet of origins and destinations into a published arc map in PlotSet, from placing coordinates to filtering, publishing and embedding.
Cerca de 8 minutosOne curved line per route, drawn across a world map from your own origins and destinations: that is how to create an arc map from a spreadsheet, with thickness showing volume, colour showing a category, and a filter so viewers can isolate one group. It runs through the same click path any published PlotSet chart takes, with your own routes rather than placeholder rows.
If your sheet already has latitude and longitude for both ends of every route, it takes about eight minutes. Allow longer if you only have place names, since the template needs coordinates and looking them up is the one chore an arc map adds.
One row per route with six required columns: origin name, origin latitude, origin longitude, destination name, destination latitude, destination longitude. Optional columns add arc size, a colour category and a filter group.
| Origin | Origin lat | Origin lng | Destination | Destination lat | Destination lng | Passengers (000s) | Region |
|---|---|---|---|---|---|---|---|
| London | 51.5074 | -0.1278 | New York | 40.7128 | -74.0060 | 620 | Transatlantic |
| London | 51.5074 | -0.1278 | Dubai | 25.2048 | 55.2708 | 550 | Europe-Middle East |
| London | 51.5074 | -0.1278 | Singapore | 1.3521 | 103.8198 | 480 | Europe-Asia |
| Tokyo | 35.6762 | 139.6503 | Los Angeles | 34.0522 | -118.2437 | 410 | Transpacific |
Use decimal degrees. Latitude runs from -90 to 90 and longitude from -180 to 180; southern and western places are negative.
Do not swap the columns. If a route lands in the ocean or on the wrong continent, latitude and longitude are almost always reversed.
Keep coordinates as plain numbers with no degree symbols or N/S suffixes, or the row cannot be placed.
The size column should be numeric. The colour and filter columns are text categories, so keep the spelling consistent or one group will split in two.
O caminho exato no PlotSet, de um modelo em branco até o gráfico finalizado.
From the PlotSet dashboard, start a new project and choose Arc Map, listed under Maps. It loads with sample world air routes already bound, so you can see the column layout before using your own file.
Put the origin and destination names and coordinates on the same row. If you only have city names, look up their coordinates first and add them as columns.
Import a CSV or .xlsx file from the data panel, paste rows from a spreadsheet, or connect a Google Sheet so the map can be refreshed later. The first row is read as the column headers.
Confirm which columns are the origin, destination and coordinates. Then bind the optional size column to arc thickness, the category column to colour, and a filter column if you want viewers to isolate a group.
Open the Map tab to choose a flat Mercator view or a rotatable globe, and a light, dark or muted base map. A quiet base makes the arcs stand out.
In the Arc tab set how curved the routes are, how thickness scales with your size column, and whether colour comes from a category or a gradient. Turn on arrowheads if direction matters.
Enable the filter control to show a dropdown or buttons, and place the legend so the colour categories are explained.
Publish for a live, zoomable map where hovering an endpoint highlights its routes, copy the embed code for your page, or export a PNG, SVG or PDF for a static image.
Comece pelo modelo de Arc Map com dados de exemplo já carregados, depois substitua-os pelos seus.
Abrir o modeloA reta final é igual para todo tipo de gráfico: o Share transforma o gráfico em um link público interativo e em um código de incorporação; o Export gera um arquivo estático.
Ativar o código de incorporação e o link público é o que publica o gráfico. O link pode ser enviado com segurança para qualquer pessoa, e o código de incorporação entra em qualquer página como um iframe que mantém a interatividade e os tooltips ao passar o mouse. Edite o gráfico depois e clique em Recreate para levar essas mudanças aos dois.
O Export grava uma cópia estática no tamanho que você precisar. O SVG continua nítido em qualquer escala e ainda pode ser editado em uma ferramenta de design; PNG e JPG são as escolhas seguras para slides e documentos. É o multiplicador de escala que garante uma imagem nítida em uma tela retina.
Scaling arc width by passengers or tonnes shows which routes matter. Choose a square-root or log scale when a few routes dwarf the rest.
A pale, low-contrast base keeps attention on the routes. Save dark bases for light arcs.
Rather than dropping routes, give them a group column and let viewers switch between them.
Add a line to the header or legend, such as thickness shows passengers in thousands, so nobody reads width as distance.
Latitude and longitude are probably swapped. Latitude is the north to south number and must stay between -90 and 90.
A coordinate was probably read as text, often from a degree symbol or a stray space. Clean the cell to a plain number and re-upload.
Too many routes at equal weight. Bind a size column, add a filter group, or aggregate to region pairs.
Não tem certeza se o Arc Map é a escolha certa? Veja o que é, quando usar e quando evitar.
Origin name, origin latitude and longitude, destination name, and destination latitude and longitude, one route per row. Size, colour and filter columns are optional.
Grátis para começar com mais de 300 modelos. Sem cartão de crédito.
