A step by step walkthrough for plotting two numeric columns from your own spreadsheet in PlotSet, grouping the points by category, and publishing, embedding or exporting the result.
约 7 分钟This guide covers how to create a scatter plot in PlotSet from your own numbers, not a demo dataset: two numeric columns bound to X and Y, an optional category column colouring the points into groups, and axes and labels that actually say what the numbers mean. By the end you will have gone through the same click path a published PlotSet chart takes, from a raw spreadsheet to something you can embed or drop into a deck.
Seven minutes covers it when your sheet already has two clean numeric columns, most of that spent on labelling and styling rather than wrestling the data itself. Pulling numbers out of a wider report, or cleaning up a category column for grouping, adds another five to ten.
One row per record, with two numeric columns for the axes plus an optional label column and an optional category column for colour grouping. Just one header row, no merged cells.
| Campaign | Channel | Spend | Revenue |
|---|---|---|---|
| Spring Launch | Paid Search | 4200 | 18900 |
| Summer Sale | Paid Search | 6100 | 24300 |
| Back to School | Paid Social | 3800 | 11200 |
| Holiday Push | Paid Social | 7200 | 19800 |
| Retargeting Q1 | 1200 | 9800 | |
| Newsletter Promo | 900 | 6200 | |
| Influencer Collab | Paid Social | 5400 | 15100 |
| Display Retarget | Paid Search | 2600 | 10400 |
Both axis columns need to be numbers, not text that merely looks numeric. A currency symbol or a thousands separator left in as text will stop the column from binding to an axis, so strip formatting before uploading.
The label column (here, Campaign) is optional but worth keeping: it is what shows up in the tooltip and in any point labels you turn on later, instead of a bare coordinate.
The category column (here, Channel) is optional too. Skip it for a plain single-colour scatter plot, or keep it if you want the points grouped and coloured by that channel, region or segment.
One row per record, not per aggregate. If your source is already a pivot table of averages, decide whether you actually want the underlying rows plotted or a smaller, pre-aggregated table instead.
PlotSet 中从空白模板到完成图表的具体点击路径。
From the PlotSet dashboard, start a new project and choose the Scatter Plot template. It loads as a scatter plot with groups and comes with sample data already bound, so you can see the exact column layout it expects before touching your own file.
Put your two numeric measures in their own columns, add a label column if you want readable tooltips, and add a category column only if you plan to colour the points by group. Drop any subtotal or average row before uploading.
Import a CSV or .xlsx file from the data panel, paste rows straight from a spreadsheet, or connect a Google Sheet if you want later edits to flow through without a re-upload. PlotSet reads the first row as headers automatically.
Assign one numeric column to the X axis and the other to Y. PlotSet usually guesses correctly when your headers are clear, but check the mapping manually if your sheet carries extra numeric columns it might have picked the wrong one from.
If you included a category column, bind it to colour so each group gets its own shade and its own entry in the legend. Skip this step entirely for a single-series scatter plot: one colour is correct when there is nothing to group.
Name both axes with real units, not just the column header. Turn on point labels for the handful of records that matter, usually the outliers, and leave the rest to the hover tooltip so the chart does not turn into a wall of text.
Reduce mark size or add transparency if points are stacking into a solid blob. Only turn on the fitted trend line once you have actually looked at the shape of the cloud, since a straight line through a curved or clustered relationship reports a pattern that is not there.
Publish for a live interactive chart with hover tooltips and a shareable link, copy 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 report.
从已加载示例数据的 Scatter Plot 模板开始，再替换成你自己的数据。
打开模板最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
Past that, the legend and the eye both lose track of which shade is which. If your category column has more groups than that, filter to the ones that matter for the story or fall back to a single colour and call out one group with a label instead.
If the cloud reads as one dark shape, the fix is almost never a bigger chart. Drop the mark opacity to around 50 to 70 percent, or shrink the point size, so overlapping records show up as darker patches instead of one flat blob.
Do not zoom the axis in to make a weak relationship look tighter. Start from the full range of your data and only narrow it if you are explicitly calling out a subset, with a caption saying so.
The point worth a label is usually the one that breaks the pattern, not every point in a given group. Turn on manual point labels and pick the two or three records that carry the story, leaving the rest to the tooltip.
This usually means the category column was read as a number rather than text, so PlotSet tried to bind it to size or a colour scale instead of discrete groups. Check the column type in the data panel and force it to text if a category name looks like a code or an ID.
This is overplotting: too many points landing on top of each other at the resolution you are viewing. Lower the mark opacity, shrink the point size, or filter to a date range or subset before assuming the two variables have no relationship at all.
A linear trend line forces a straight line through data that might be curved, clustered into two groups, or dominated by one outlier. Turn the trend line off, look at the raw shape of the points, and only re-enable it if a straight line is genuinely the right summary.
不确定 Scatter Plot 是否是正确选择？查看它是什么、何时使用以及何时不使用。
Two numeric columns, one per axis, with one header row. A label column and a category column are optional additions that drive the tooltip text and the colour grouping. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
免费开始，300+ 模板任选。无需信用卡。
