示例 CSV
| 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.
约 6 分钟By 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.
你需要的数据
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.
操作步骤
PlotSet 中从空白模板到完成图表的具体点击路径。
- 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.
每份指南都从这里开始：先选分类，再选模板，不管你要做哪种图表，用的都是同一个网格。 - 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.
这里的数据视图取自一个条形图项目。你可以上传 CSV、用「Magic Import」从图片里提取数字，或同步 Google Sheet，每种图表类型的面板都一样。 - 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.
绑定决定哪一列作标签、哪一列提供数值、哪一列决定颜色。「Auto Binding」（自动绑定）会根据表头推测，所以要核对一遍，别想当然。 - 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.
Bar Chart 的「Preview」标签页。所有样式设置都在红框标出的这个面板里，每个设置各自占一个标签页：外观、标题、脚注，以及这种图表类型特有的选项。 - 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.
从已加载示例数据的 Bar Chart 模板开始，再替换成你自己的数据。
打开模板发布、嵌入或导出
最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
Share：公开链接与嵌入代码
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
Export：SVG、PNG 或 JPG
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
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.
制作 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.
深入了解 Bar Chart
不确定 Bar Chart 是否是正确选择？查看它是什么、何时使用以及何时不使用。
Bar Chart：常见问题
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.
现在制作你的 Bar Chart
免费开始，300+ 模板任选。无需信用卡。