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.
Environ 8 minutesOne 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.
Le parcours exact dans PlotSet, d'un modèle vierge à un graphique terminé.
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.
Partez du modèle Arc Map avec des données d'exemple déjà chargées, puis remplacez-les par les vôtres.
Ouvrir le modèleLa dernière ligne droite est la même pour tous les types de graphique : 'Share' transforme le graphique en lien public actif et en code d'intégration, 'Export' l'enregistre sous forme de fichier statique.
Activer le code d'intégration et le lien public revient à publier le graphique. Le lien peut être envoyé à qui vous voulez sans risque, et le code d'intégration s'insère dans n'importe quelle page sous la forme d'une iframe qui conserve les infobulles au survol et l'interactivité. Si vous modifiez le graphique par la suite, cliquez sur 'Recreate' pour répercuter ces changements sur le lien comme sur le code.
Le bouton 'Export' génère une copie statique à la taille dont vous avez besoin. Le SVG reste net à toutes les échelles et peut encore être modifié dans un outil de design ; PNG et JPG sont les choix sûrs pour les présentations et les documents. C'est le multiplicateur d'échelle qui vous donne une image nette sur un écran 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.
Vous n'êtes pas sûr que le Arc Map soit le bon choix ? Découvrez ce que c'est, quand l'utiliser et quand l'éviter.
Origin name, origin latitude and longitude, destination name, and destination latitude and longitude, one route per row. Size, colour and filter columns are optional.
Gratuit pour commencer avec plus de 300 modèles. Aucune carte bancaire requise.
