示例 CSV
| Channel | Budget |
|---|---|
| Paid Search | 42000 |
| Social Ads | 31000 |
| 18500 | |
| Content | 12000 |
| Events | 9500 |
| Other | 6000 |
How to Create a Donut Chart
A step by step walkthrough for turning a spreadsheet into a published donut chart in PlotSet, from shaping the sheet to filling the centre hole and exporting or embedding the finished ring.
约 7 分钟A marketing budget split across five channels, paid search, social ads, email, content and events, with one honest "Other" row for the rest, is the working example for how to create a donut chart in PlotSet. By the end you'll have a published, interactive ring chart with the total budget sitting in the centre hole, built from your own categories, not a screenshot of someone else's.
If your spreadsheet is already two columns, category and value, this takes about seven minutes. Add a few more if you're pulling the numbers out of a wider report, or if you're still deciding what belongs in "Other". Budget the walkthrough below and treat the rest as buffer.
你需要的数据
Two columns, one row per category: the category name first, its raw value second. No totals row, one header row, and categories that genuinely add up to the whole you're describing.
Keep the value column as raw numbers, not percentages you've already worked out. PlotSet calculates each segment's share of the total itself, so a percent sign in that column throws the math off.
Roll anything under a few percent of the total into a single "Other" row before you upload. Eight thin slivers read worse than one clearly labelled bucket.
Delete a totals row before uploading, the same rule as any summed chart. Uploaded as data, a "Total" row becomes its own segment, usually the biggest one on the ring.
Category names need to be unique. Two rows both labelled "Misc" or "Other" get merged or duplicated depending on your spreadsheet's export, so rename one before you upload.
操作步骤
PlotSet 中从空白模板到完成图表的具体点击路径。
- 01
Open the donut chart template
From the PlotSet dashboard, start a new project and pick the Donut Chart template. It loads with sample data already in place, so you can see the two-column shape it expects before touching your own file.
每份指南都从这里开始：先选分类，再选模板，不管你要做哪种图表，用的都是同一个网格。 - 02
Shape your sheet into two columns
Category name in the first column, its number in the second, one row per category. If you're working from a pivot table, flatten it first: the upload should be nothing but categories and values, no subtotals mixed in.
- 03
Import your data or connect a sheet
Import a CSV or .xlsx from the data panel, paste rows straight from a spreadsheet, or connect a Google Sheet if you want the ring to refresh later without a re-upload. PlotSet reads the first row as headers automatically.
这里的数据视图取自一个条形图项目。你可以上传 CSV、用「Magic Import」从图片里提取数字，或同步 Google Sheet，每种图表类型的面板都一样。 - 04
Point PlotSet at the category and value columns
Confirm which column feeds the segment labels and which feeds the angles. PlotSet usually guesses right when your headers are clear, but check it manually if the sheet carries extra columns it might have picked up by mistake.
绑定决定哪一列作标签、哪一列提供数值、哪一列决定颜色。「Auto Binding」（自动绑定）会根据表头推测，所以要核对一遍，别想当然。 - 05
Order the segments and switch on percentage labels
Sort largest to smallest so the eye has a path around the ring instead of hunting for it. Turn on percentage labels directly on each segment: angles alone are hard to judge, and the number removes the guesswork.
- 06
Put the total in the centre hole
Set the centre text to the sum of your value column, not a default label PlotSet might have picked. This is the one thing a donut can do that a pie can't, so it's worth checking rather than leaving on auto.
- 07
Pick a colour set and a title
Use shades of one hue for a ranked set of related categories, or distinct colours only when the categories are genuinely different things. Reserve a stand-out colour for the one segment you want to highlight. Give the chart a title that states what's being split, not just the word "budget".
Donut Chart 的「Preview」标签页。所有样式设置都在红框标出的这个面板里，每个设置各自占一个标签页：外观、标题、脚注，以及这种图表类型特有的选项。 - 08
Publish, embed or export the ring
Publish for a live, interactive ring with hover tooltips and a shareable link, grab the embed code for a page, or export a PNG, SVG or PDF if you need a static image for a deck or report.
从已加载示例数据的 Donut Chart 模板开始，再替换成你自己的数据。
打开模板发布、嵌入或导出
最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
Share：公开链接与嵌入代码
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
Export：SVG、PNG 或 JPG
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
Donut Chart 的样式提示
Keep the hole wide enough to read
A thin ring with a cramped centre makes the total illegible and the segments hard to click. Widen the hole until the centre number sits comfortably on its own line, with a small caption underneath naming what it is.
Label segments directly once you're under six
With five categories or fewer, put the label and percentage right on or beside each arc and drop the separate legend. It removes the lookup step between colour and category entirely, which a legend never quite avoids.
Match colour intensity to size, not to preference
For a ranked breakdown, ordering shades from darkest (largest share) to lightest (smallest) reinforces the sort visually. Save a genuinely different colour for a category you're calling out on purpose, like this year's new channel.
Round the centre number to something readable
A centre total of $118,517.42 is precision nobody needs at a glance. Round to a sensible unit ($119K, or 42%) and let the data table underneath carry the exact figure for anyone who wants it.
制作 Donut Chart 时的常见错误
The ring doesn't visually read as a full 100%
This usually means two categories overlap, or one is a rate or an average rather than a slice of the same total. Check your source data for a row that doesn't belong to the same whole as the rest, and pull it into its own chart if it doesn't.
Small segments overlap their own labels
Below a few percent, a label has nowhere to sit without colliding with its neighbour. Roll those rows into a single "Other" category before upload rather than fighting label placement after the fact.
The centre shows the wrong number
Left on its default, the centre sometimes displays a segment count or the largest value instead of the total you want. Open the centre text setting and point it at the sum explicitly, then re-check it after any edit to the underlying rows.
深入了解 Donut Chart
不确定 Donut Chart 是否是正确选择？查看它是什么、何时使用以及何时不使用。
Donut Chart：常见问题
Two columns and one header row: category names in the first column, one raw number per category in the second. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too. Don't pre-calculate percentages; PlotSet does that from the raw values.
现在制作你的 Donut Chart
免费开始，300+ 模板任选。无需信用卡。