CSV de exemplo
| Department | Headcount |
|---|---|
| Engineering | 84 |
| Sales | 52 |
| Customer Support | 37 |
| Marketing | 29 |
| Finance | 18 |
| Operations | 15 |
How to Create a Bar Chart
A step by step walkthrough for turning a spreadsheet into a published bar chart in PlotSet, from shaping the sheet to exporting or embedding the finished chart.
Cerca de 6 minutosBy the end of this guide you will have a published, interactive bar chart built from your own spreadsheet: sorted, labelled, coloured on purpose, and either embedded on a page or exported as an image for a deck. Not a screenshot of someone else's example, your own categories and your own numbers, going through the same click path a real PlotSet chart takes from upload to publish.
If your spreadsheet is already in two columns, category and value, this takes about five minutes. Add ten more if you are still cleaning up a messier export: merging duplicate category names, deciding what to do with a stray blank row, or pulling one column out of a wider report. Budget the six minutes below and treat the rest as a buffer.
Os dados que você precisa
Two columns, one row per category: the category name first, the number second. No totals row, no merged cells, one header row.
Keep the category column as plain text. If a spreadsheet turns "Q1" or a department code into a date or a formula result, PlotSet will chart the underlying value, not the label you intended.
One number per category. If you are tracking a category across several time periods, that is a grouped or stacked bar chart, not this one: see the grouped bar chart guide for the extra column that setup needs.
Delete any totals or subtotals row before uploading. A "Total" row uploaded as data becomes a bar of its own, usually the tallest one, and throws off the sort.
Blank cells in the value column render as zero-length bars rather than being skipped. Fill them in or remove the row.
Os passos
O caminho exato no PlotSet, de um modelo em branco até o gráfico finalizado.
- 01
Open the bar chart template
From the PlotSet dashboard, start a new project and choose the Bar Chart template. It loads with sample data already in place so you can see the exact column layout PlotSet expects before you touch 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
Shape your sheet into two columns
Put the category name in the first column and its number in the second, one row per category. If your source data is a pivot table or a report with subtotals, strip those out first: the upload should be nothing but categories and values.
- 03
Upload your 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 if you want the chart to pick up edits later without a re-upload. PlotSet reads the first row as headers automatically.
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. - 04
Map the category and value columns
Confirm which column feeds the category axis and which feeds the bar length. This is usually automatic when your headers are clear, but check it manually if your sheet has extra columns PlotSet might have guessed wrong on.
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. - 05
Sort the bars
Switch the sort to descending by value unless your categories already have a natural order, such as age brackets or survey ratings. A sorted chart shows the ranking at a glance; an unsorted one makes the reader hunt for it.
- 06
Add value labels and drop the gridlines
Turn on labels at the end of each bar so the exact number is readable without measuring against the axis. Once every bar carries its own number, the background gridlines are usually redundant and the chart reads cleaner without them.
- 07
Pick one colour and a title
With a single series, one consistent colour is correct: colour is not carrying any information here, so a rainbow of bar colours only adds visual noise. Save a second colour for a highlight if you want to draw attention to one specific bar. Add a chart title that states the comparison, not just the metric.
A aba Preview de um gráfico do tipo Bar Chart. 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. - 08
Publish, embed or export
Publish for a live, interactive chart 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 Bar Chart 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 Bar Chart
Horizontal bars for long category names
If your categories are anything longer than a short code, department names, product names, survey questions, keep the chart horizontal. Long labels get a full line each with no rotating or truncating, which is the main reason to reach for a bar chart over a column chart in the first place.
Start the value axis at zero, always
Bar length is the encoding, so a truncated axis exaggerates every gap on the chart. If you are tempted to zoom in on a narrow range of similar values, add value labels instead and leave the axis at zero.
Cap it around twenty five bars
Past roughly twenty five categories, a bar chart turns into a wall of thin lines nobody can compare. Filter to your top group (top 10, top N by region, whatever the story actually needs) and mention in the title or a caption that it is a subset.
Reserve colour for one comparison at a time
If you do need a second colour, use it for exactly one thing: the category you are calling out, or a threshold like "above target" versus "below target." Two colours used for one clear reason read better than four colours used for none.
Erros comuns ao fazer um Bar Chart
The bars come in alphabetical order, not ranked
This means the sort setting is still on the default (usually by category, not by value). Open the sort control in the chart settings and switch it to sort by the value column, descending.
One bar is far taller than the rest for no obvious reason
Check the raw data for a totals or subtotals row that got uploaded along with the real categories. Delete that row from the source sheet and re-upload, or remove it directly in PlotSet's data table.
A category is missing or merged with another
This usually means two rows in the source spreadsheet had category names that differ only by trailing spaces, capitalization or a stray character. Clean the category column in your spreadsheet (a TRIM formula catches most of it) before re-uploading.
Saiba mais sobre o Bar Chart
Não tem certeza se o Bar Chart é a escolha certa? Veja o que é, quando usar e quando evitar.
Bar Chart: perguntas frequentes
Two columns and one header row: category names in the first column, one number per category in the second. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Crie seu Bar Chart agora
Grátis para começar com mais de 300 modelos. Sem cartão de crédito.