CSV de exemplo
| Country | CO2 per Capita (tonnes) |
|---|---|
| United States | 14.2 |
| Germany | 8.1 |
| China | 7.6 |
| Brazil | 2.2 |
| India | 1.9 |
| Nigeria | 0.6 |
How to Create a Choropleth Map
A step by step walkthrough for turning a spreadsheet of place names and numbers into a published choropleth map in PlotSet, from matching region names to exporting or embedding the finished map.
Cerca de 8 minutosPlace names and numbers go in; how to create a choropleth map in PlotSet comes out the other side as a published, interactive map you can share or embed. You will end up with regions shaded by your own values, a color scale that actually fits the data, and a legend that tells the reader what the shading means: not a screenshot of somebody else's country list with your numbers dropped in.
If your spreadsheet already uses the exact place names PlotSet's map template recognizes, this takes about eight minutes. Add another ten if you are starting from a report full of abbreviations, ISO codes or older country names: matching those to the template's region list is the part that eats time, not the styling. Budget the eight minutes below and treat the rest as a buffer.
Os dados que você precisa
One row per region, two columns: the place name first, matching how the template labels its regions, and the number second. One header row, no totals row.
Use the same place names the map template uses, not abbreviations or codes. "USA" or "US" often will not match a region labeled "United States", and a mismatch drops that row's shading instead of throwing an error.
One number per region. If you want two years side by side, that calls for two separate maps or a time slider, not two columns crammed into one choropleth.
Leave regions you have no data for out of the sheet entirely, rather than filling them with a zero. PlotSet gives any region with no matching row a distinct no-data color; a zero would shade it like a real low value instead.
Delete any totals or world-aggregate row before uploading. A "Global" or "World" row has no matching region on the map, so it gets ignored, but it is cleaner to remove it at the source than to rely on that.
Os passos
O caminho exato no PlotSet, de um modelo em branco até o gráfico finalizado.
- 01
Open the Choropleth Map template
From the PlotSet dashboard, start a new project and choose the Choropleth Map template. It loads with a world map and sample data already in place, so you can see the place-name and value columns the template expects before swapping in your own file.
Todo guia começa aqui. Escolha a categoria e depois o modelo: a grade é a mesma, seja qual for o tipo de gráfico que você quer. - 02
Pick the map that matches your data's geography
Choose world countries, or one of the state, province and county maps in the template library if your rows sit below the country level. Settling this first avoids a second round of place-name matching once you realize the template you started with is the wrong scale.
- 03
Shape your sheet into a place column and a value column
Put the region name in the first column and its number in the second, one row per region. Use standard names rather than abbreviations, ISO codes or postal codes: whatever format the map template's region list expects.
- 04
Upload the file, or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet so the map can pick up updated figures later without a re-upload.
A visualização de dados, aqui em um projeto de gráfico de barras. Envie um CSV, extraia os números de uma imagem com o Magic Import ou sincronize um Google Sheet. O painel é idêntico para todos os tipos de gráfico. - 05
Check the unmatched-region list
After upload, confirm which column PlotSet read as the place name and which as the value. Then look at the unmatched list it shows: any row whose name did not find a region on the map lands there, and it is almost always a spelling or naming difference you can fix in seconds.
Os vínculos definem qual coluna vira o rótulo, qual fornece os valores e qual comanda a cor. O Auto Binding tenta adivinhá-los a partir dos seus cabeçalhos, então confira o resultado em vez de dar como certo. - 06
Choose a color scale and set the no-data color
Use a single-hue sequential scale, light to dark, for ordinary low-to-high figures, and switch to a diverging scale only when your numbers have a real midpoint, such as zero or a national average. Set a distinct gray for regions with no matching data so missing never reads as low.
A aba Preview de um gráfico do tipo Choropleth Map. Todos os controles de estilo ficam no painel contornado em vermelho: aparência, cabeçalho, rodapé e as opções específicas desse tipo de gráfico. Cada grupo fica em sua própria aba. - 07
Add a legend and a title that names the measure
Turn on the legend so the shading has a key, and title the map with what is being measured, "CO2 emissions per capita" rather than just "Map". A reader should know what the color means before they hover over a single region.
- 08
Publish, embed or export the map
Publish for a live, interactive map with hover tooltips and a shareable link, grab the embed code to drop it into a page, or export a PNG, SVG or PDF if you need a static image for a deck or a report.
Comece pelo modelo de Choropleth Map com dados de exemplo já carregados, depois substitua-os pelos seus.
Abrir o modeloPublique, incorpore ou exporte
A 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.
Share: link público e código de incorporação
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.
Export: SVG, PNG ou JPG
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.
Dicas de estilo para um Choropleth Map
Match names to the template, not to each other
PlotSet's map templates use a fixed list of region names per geography. Before uploading, check your trickier entries (small countries, disputed territories, recently renamed regions) against the template's own list rather than assuming your source spreadsheet's spelling counts as standard.
Shade rates, not raw counts
Land area does not track population, so a map colored by total count usually just redraws where people live. Convert to a rate, share or per-capita figure before shading, and save the raw totals for a bar chart instead.
Keep one level of geography per map
A single choropleth should shade one scale at a time: country, or state, not both mixed together. If you need a national overview and state-level detail, build two maps rather than combining region sizes on one, which breaks the color scale's comparison.
Label the no-data color in the legend
A gray swatch with no explanation leaves the reader guessing whether it means zero or unknown. Label it "No data" directly in the legend so the distinction is stated, not inferred from context.
Erros comuns ao fazer um Choropleth Map
Regions are missing shading even though they're in your sheet
This is almost always a name mismatch: your sheet says "USA" or "Ivory Coast" while the map template expects "United States" or "Côte d'Ivoire". Open the unmatched-rows list PlotSet shows after upload and correct the spelling for each name it flags, then re-upload.
The map looks like a population map, not your actual metric
Check whether you uploaded a raw count instead of a rate. Totals shade almost any map the same way a population map would, since bigger, denser regions post bigger numbers regardless of what you meant to measure. Divide by population or another sensible denominator and re-upload.
Missing regions look identical to low values
If every unshaded region sits at the same pale end of the scale as your lowest real values, the no-data color was probably never set. Open the color settings, assign a distinct gray to no-data, and leave regions you have no figure for out of the sheet entirely.
Saiba mais sobre o Choropleth Map
Não tem certeza se o Choropleth Map é a escolha certa? Veja o que é, quando usar e quando evitar.
Choropleth Map: perguntas frequentes
One column of place names and one column of numbers, with one row per region and one header row. The place names need to match the names the map template uses, standard country or state names rather than abbreviations or ISO codes, or that row's region will not get shaded.
Crie seu Choropleth Map agora
Grátis para começar com mais de 300 modelos. Sem cartão de crédito.