示例 CSV
| Date | Solar | Wind | Hydro |
|---|---|---|---|
| 2010-01-01 | 32 | 181 | 1020 |
| 2015-01-01 | 222 | 417 | 1209 |
| 2020-01-01 | 714 | 733 | 1332 |
| 2024-01-01 | 1419 | 1017 | 1412 |
视频模板
Animated Column Chart Race Maker
Turn a spreadsheet of values over time into an animated column chart: vertical bars grow upward and swap places as your data moves through time. Upload a CSV, pick your columns, export an MP4.
预览即将推出
Race Columnanimated column chart
什么是 Race Column？
Rotate a bar chart race ninety degrees and you get an animated column chart: instead of bars stretching sideways from the left edge, columns grow straight up from a shared baseline, swapping left-right order as one overtakes another. It's the same underlying idea as a bar chart race, a leaderboard that visibly reshuffles instead of a table you compare row by row, just standing up instead of lying down.
That rotation isn't cosmetic. Columns read better than horizontal bars once you're down to a handful of series, because the eye tracks height changes quickly and the layout fits naturally into a square or vertical frame: an Instagram post, a Story, a portrait-oriented slide. A ten-bar horizontal race needs a wide canvas to keep labels legible; five or six columns sit comfortably in a square crop without cramming text.
PlotSet's Race Column template renders this from a plain wide-format sheet: no keyframing, no animation software required. Upload dates down the left and one column per entity, and the template interpolates the motion between each row, so the columns rise and swap smoothly even when your source data only has a few time steps, four in the solar, wind and hydro sample above.
您需要的数据
按照这样的格式准备数据表，Race Column 模板就能自动生成。
Date
One row per point in time, oldest first. Each remaining column is a column.
The sheet is wide, not long: one row per time step, one column per entity, exactly like the sample above with Date, Solar, Wind and Hydro as separate fields. If your source data has a separate row for every entity-and-date pair (common when it comes straight out of a database), pivot it so each entity gets its own column before uploading.
Rows need to be in chronological order, oldest first, and the date column has to parse as an actual date. You don't need even spacing: the sample above jumps from 2010 to 2015 to 2020 to 2024 and still renders a clean race, but more rows give PlotSet more points to interpolate between, so the columns rise and swap more smoothly. Four or five time steps is enough to animate; eight or more starts to look genuinely fluid.
何时创建 Race Column
A handful of series, not a dozen
Three to six columns is where this format shines: energy sources, product lines, a few competing brands. Wide horizontal bars start to feel cramped as label count grows; upright columns hit a ceiling sooner but look cleaner within it.
Square and vertical social formats
Instagram feed posts, Stories and TikTok crops are taller than they are wide. A column race fills that frame naturally, where a wide bar race would need heavy cropping or shrunk-down labels to fit.
Totals that climb over time
Cumulative installs, capacity or output, anything trending upward, reads intuitively as columns rising toward the top of the frame, echoing how a growth chart is normally drawn.
Dashboards and decks with a portrait slide
If the destination is a vertical slide or a printed one-pager, a column layout matches the page orientation instead of fighting it.
何时不需要它
Long lists of competing entities
Once you're past eight or nine columns, the labels underneath start overlapping or getting cut. Switch to Race Bar, where horizontal space scales better with entity count.
Widescreen video destinations
For YouTube or a 16:9 deck, a horizontal bar race uses the frame's width more naturally. Save the column layout for square or vertical placements.
Precise value comparisons
Columns are still in motion, so nobody's reading exact heights off the screen. Pair the video with a static chart or table if the specific numbers need to be citable.
如何创建 Race Column
从电子表格到渲染的 MP4，一步一步来。
Open the Race Column template
PlotSet loads Race Column with the solar, wind and hydro capacity data used throughout this page, so you can see the expected sheet layout before touching your own file.
Shape your sheet as one column per bar
First column is the date, oldest row first. Every other column is one entity that gets its own vertical column, and its header becomes the label underneath it.
Upload your CSV or Excel file
Import a CSV, an .xlsx file, or paste directly from a spreadsheet. The template reads the header row automatically and maps a column to each numeric field.
Choose colors and set the pacing
Assign a color per entity, pick a typeface, and set how long the race plays before settling on the final order. Add a music track if the export is headed to social.
Render on PlotSet's servers and download
Preview the animation, then render. PlotSet renders the MP4 on its servers, so there's nothing to install: download the file when it's done, or share the link directly.
从已加载示例数据的 Race Column 模板开始，再替换成您自己的数据。
打开模板Race Column：常见问题
Same animation, different orientation. A bar chart race grows bars sideways from the left; a column chart race grows columns upward from the bottom. Columns suit fewer series and square or vertical crops better, while horizontal bars handle longer lists more comfortably.
立即渲染您的 Race Column
免费开始。无需信用卡。