示例 CSV
| Quarter | New | Renewal | Expansion |
|---|---|---|---|
| Q1 2025 | 120000 | 340000 | 45000 |
| Q2 2025 | 145000 | 360000 | 52000 |
| Q3 2025 | 138000 | 375000 | 61000 |
| Q4 2025 | 162000 | 390000 | 74000 |
How to Create a Stacked Column Chart
A step by step walkthrough for turning a spreadsheet into a published stacked column chart in PlotSet, from shaping the columns to ordering the stack and exporting the result.
约 8 分钟This guide covers how to create a stacked column chart in PlotSet, starting from a raw spreadsheet and ending with a chart you can publish, embed or export. You will end up with columns that show both a total and the parts underneath it, stacked in an order you chose on purpose, not whatever order your spreadsheet happened to list the columns in.
Eight minutes, roughly, if your data already sits one row per period with a clean numeric column for each segment. Pulling those numbers out of a pivot table first adds a few more, and it's the step most people underestimate: flattening a wide report into the one-row-per-period shape this chart actually needs.
你需要的数据
One row per time period or category, with the period in the first column and one numeric column per segment. Every numeric column becomes one band in the stack, in the order the columns appear.
Keep the period column as plain text, not a date field. If a spreadsheet auto-converts "Q1 2025" into a date, PlotSet will chart whatever that date resolves to, not the label you typed.
Do not add a Total column. PlotSet sums the segment columns itself to draw the full column height, and an extra total column will get read as one more band, roughly doubling every column's apparent size.
Every segment needs its own column with a consistent header across every sheet you upload. A segment named "Renewal" in one file and "Renewals" in another counts as two different bands, not one.
A blank cell in a segment column renders as a zero-height band rather than being skipped, so a quarter with no expansion revenue still needs a 0 in that cell, not an empty one.
操作步骤
PlotSet 中从空白模板到完成图表的具体点击路径。
- 01
Open the stacked column chart template
From the PlotSet dashboard, start a new project and choose the Stacked Column Chart template. It loads with sample data already shaped correctly, so you can see the column layout before you touch your own file.
每份指南都从这里开始：先选分类，再选模板，不管你要做哪种图表，用的都是同一个网格。 - 02
Shape your sheet into one row per period
Put the time period or category in the first column and one numeric column per segment after it. If your source is a pivot table with the segments spread across a wider report, flatten it into this layout before you upload anything.
- 03
Import the file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows straight from a spreadsheet, or connect a Google Sheet if you want the chart to update later without a re-upload. PlotSet reads the first row as your segment headers.
这里的数据视图取自一个条形图项目。你可以上传 CSV、用「Magic Import」从图片里提取数字，或同步 Google Sheet，每种图表类型的面板都一样。 - 04
Confirm the axis column and the segment columns
Confirm which column feeds the horizontal axis and which columns feed the stack. This is usually correct automatically, but check it if your sheet carries extra columns, like a growth rate or a note field, that should not be charted as a band.
绑定决定哪一列作标签、哪一列提供数值、哪一列决定颜色。「Auto Binding」（自动绑定）会根据表头推测，所以要核对一遍，别想当然。 - 05
Set the stack order
Drag the segments into the order you want them to appear, bottom to top. Put whichever series your reader most needs to compare across periods at the bottom, since that is the only band sitting on a shared baseline.
Stacked Column Chart 的「Preview」标签页。所有样式设置都在红框标出的这个面板里，每个设置各自占一个标签页：外观、标题、脚注，以及这种图表类型特有的选项。 - 06
Decide between raw values and percentages
Leave the chart on raw values if the totals themselves are part of the story. Switch to the 100% stacked variant if you only care about how the share of each segment shifted, since that view normalises every column to the same height.
- 07
Style the bands, add labels, and publish
Give each segment a distinct colour, turn on a total label above the column if the sum is worth calling out, and confirm the value axis starts at zero. Then publish for a live embed with hover tooltips, or export a PNG, SVG or PDF.
从已加载示例数据的 Stacked Column Chart 模板开始，再替换成你自己的数据。
打开模板发布、嵌入或导出
最后一段路对每种图表都一样：「Share」（分享）把图表变成一个在线的公开链接和一段嵌入代码，「Export」（导出）把它输出成静态文件。
Share：公开链接与嵌入代码
打开嵌入代码和公开链接的开关，图表就发布出去了。链接可以放心发给任何人；嵌入代码以 iframe 的形式放进任意页面，悬停提示和交互效果都会保留。之后修改了图表，点「Recreate」就能把改动同步到链接和嵌入代码两边。
Export：SVG、PNG 或 JPG
「Export」会按你需要的尺寸输出一份静态副本。SVG 放到多大都清晰，还能在设计工具里继续编辑；幻灯片和文档用 PNG 或 JPG 最稳妥。想让图片在高分屏上够锐利，关键就是那个倍数设置。
Stacked Column Chart 的样式提示
Bottom slot goes to the series you actually compare
Every band above the bottom one floats at a different starting height in each column, which makes it hard to compare by eye. If your reader needs to track one segment closely across periods, put that segment on the baseline, not the total.
Add a total label when the sum is the headline
Reading a stacked total off the value axis is imprecise, since it means adding up several segment heights by eye. If the total itself is news (revenue crossed a milestone, headcount hit a target) turn on the label that prints it above the column.
Only switch to 100% stacking if totals genuinely do not matter
The percentage view hides the totals completely to make shares easy to compare. That is the right trade when a reader only cares about proportion, and the wrong one the moment someone asks "but how big was Q3 actually?"
Pick colours that stay distinct at three bands and start to break at six
A handful of clearly different hues works for two to five segments. Once you are past five, either merge the smallest categories into an "Other" column before upload, or the bands start blurring into a colour gradient nobody can read accurately.
制作 Stacked Column Chart 时的常见错误
One column is far taller than the rest
This almost always means a segment column snuck in that duplicates a total, or one column is in different units than the others (dollars next to thousands of dollars). Check every segment column for a matching scale before you upload again.
The bands appear in a different order in different columns
PlotSet stacks columns in the order the segment columns are mapped, so this happens when a later batch of rows was pasted in with the segment columns rearranged. Open the data table and confirm every row uses the same column order and the same header spelling.
A small segment disappears or blends into its neighbour
Thin bands with similar default colours are hard to see, especially past four or five segments. Either assign that segment a colour that stands apart from the ones next to it, or roll the smallest categories into an "Other" column before you upload.
深入了解 Stacked Column Chart
不确定 Stacked Column Chart 是否是正确选择？查看它是什么、何时使用以及何时不使用。
Stacked Column Chart：常见问题
One row per time period or category, with the period in the first column and one numeric column per segment after it. Each of those numeric columns becomes one band in the stack, so a chart with three segments needs exactly three value columns plus the period column, and no separate total column.
现在制作你的 Stacked Column Chart
免费开始，300+ 模板任选。无需信用卡。