CSV de ejemplo
| Quarter | Revenue |
|---|---|
| Q1 2023 | 182400 |
| Q2 2023 | 205100 |
| Q3 2023 | 198750 |
| Q4 2023 | 241300 |
| Q1 2024 | 229600 |
| Q2 2024 | 256900 |
How to Create a Column Chart
A step by step walkthrough for turning a spreadsheet into a published column chart in PlotSet, from ordering the rows to exporting or embedding the finished chart.
Unos 7 minutosCategories in the order you want them, a value axis that starts at zero: how to create a column chart in PlotSet covers exactly that, styled on purpose and either embedded on a page or exported as an image. Not a copy of someone else's demo, your own periods and your own numbers, going through the same click path a real PlotSet chart takes from upload to publish.
If your spreadsheet is already two columns, category and value, with the rows already in the order you want to see, this takes about five minutes. Add a couple more if you're dealing with dates that keep auto-converting into something else, or a totals row you need to strip out first. Budget the seven minutes below and treat the rest as a buffer.
Los datos que necesitas
Two columns, one row per category: the category label first, usually a time period, and the number second. Rows should already sit in the order you want the columns to appear, since PlotSet reads them top to bottom.
Keep the category column as plain text, not a date. If a spreadsheet auto-converts "Q1 2023" into a date serial number, PlotSet charts that serial number, not the label you typed.
Row order is chart order. PlotSet lists categories top to bottom exactly as they sit in your sheet, so put Q1 2023 above Q2 2023 rather than relying on a sort step afterward.
One number per category. Comparing this year against last year in the same chart needs an extra column and a grouped or stacked column chart, not this one.
Delete any totals row before uploading. A "Total 2023" row becomes a column of its own, usually the tallest, and breaks the chronological order of everything after it.
Los pasos
El camino exacto en PlotSet, desde una plantilla en blanco hasta el gráfico terminado.
- 01
Open the column chart template
From the PlotSet dashboard, start a new project and pick the Column Chart template. It loads with sample data already in place so you can see the exact layout, category then value, before you bring your own sheet.
Todas las guías empiezan aquí. Elige la categoría y luego la plantilla. Es la misma cuadrícula sea cual sea el tipo de gráfico que busques. - 02
Shape your sheet into two columns, in order
Put the category label in the first column and its number in the second, one row per category, arranged in the order you want the columns to appear. For time periods, that means Q1 sitting above Q2 in the sheet itself, not sorted after upload.
- 03
Bring in 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 refresh when the source changes. PlotSet reads the first row as headers automatically.
La vista de datos, aquí en un proyecto de gráfico de barras. Sube un CSV, saca los números de una imagen con Magic Import o sincroniza una Google Sheet. El panel es el mismo en todos los tipos de gráfico. - 04
Map the category and value columns
Confirm which column feeds the horizontal axis and which feeds the column height. PlotSet usually guesses right when your headers are clear, like "Quarter" and "Revenue", but check it manually if your sheet carries extra columns.
Las asignaciones deciden qué columna se convierte en la etiqueta, cuál aporta los valores y cuál define el color. Auto Binding las deduce de tus encabezados, así que revísalas en lugar de darlas por buenas. - 05
Turn off auto sort for ordered categories
PlotSet defaults to ranking columns by value, which is wrong for anything with a natural sequence. Switch the sort control to source order so Q1 2023 through Q2 2024 stay chronological instead of jumping around by size.
- 06
Format the value axis and set the gap width
Add thousands separators or a currency symbol under number formatting, name the unit on the value axis, and confirm the axis minimum is 0. Set the gap between columns to roughly half a column's width: tight enough to compare, loose enough not to read like a histogram.
La pestaña Preview de un gráfico de tipo Column Chart. Todos los controles de estilo están en el panel enmarcado: apariencia, encabezado, pie de página y las opciones propias de este tipo de gráfico, cada grupo en su propia pestaña. - 07
Pick one colour, then publish
One consistent colour is correct for a single series; save a second colour for the one column you want to highlight, such as the most recent quarter. Add a title that states the comparison, then publish for a live interactive chart, grab the embed code, or export a PNG, SVG or PDF.
Empieza con la plantilla de Column Chart, que ya trae datos de ejemplo cargados, y sustitúyelos por los tuyos.
Abrir la plantillaPublícalo, incrústalo o expórtalo
El último tramo es igual en todos los tipos de gráfico: Share convierte el gráfico en un enlace público en vivo y un código de incrustación, y Export lo guarda como un archivo estático.
Share: enlace público y código de incrustación
Al activar el código de incrustación y el enlace público, el gráfico queda publicado. El enlace se lo puedes enviar a cualquiera sin problema, y el código de incrustación se coloca en cualquier página como un iframe que conserva los tooltips al pasar el cursor y toda la interactividad. Si editas el gráfico más adelante, haz clic en Recreate para llevar esos cambios a ambos.
Export: SVG, PNG o JPG
Export guarda una copia estática en el tamaño que necesites. El SVG se mantiene nítido a cualquier escala y se puede seguir editando en una herramienta de diseño; PNG y JPG son la opción segura para diapositivas y documentos. El multiplicador de escala es lo que te da una imagen nítida en una pantalla retina.
Consejos de estilo para un Column Chart
Keep the sort control off for time periods
If your categories are months, quarters or years, turn off value based sorting entirely. A chronological column chart tells a trend story; a value sorted one scrambles it into a ranking that doesn't exist in time.
Fit no more than about fifteen columns
Past that, labels start tilting or truncating and the columns thin into a picket fence. Group extra categories into an "Other" bucket, or switch to a horizontal bar chart, which handles a long list better than a column chart ever will.
Set the gap width around fifty percent
Too wide and the eye has to travel between columns to compare them; too narrow and the chart starts to look like a histogram, where touching bars mean something different: a continuous number line underneath. Fifty percent of a column's width is a safe middle.
Reserve a second colour for exactly one column
A highlight colour on the current quarter, or the category you're actually discussing, earns its place. A different hue on every column asks the reader to hunt for a grouping that isn't there.
Errores comunes al hacer un Column Chart
Quarters or months come out alphabetical, not chronological
This means the sort control is still set to rank by value or by category name instead of source order. Open the sort setting in the chart panel, switch it to source order, and check that your sheet already lists the periods top to bottom in the sequence you want.
Labels are tilted at an angle and hard to read
This shows up once you're past ten or so categories, or once a label runs longer than a word or two. Shorten the labels first, "Q1 2024" instead of "First Quarter 2024", and if that's still not enough, take it as the cue to switch to a bar chart instead.
The columns look flat, all close to the same height
Check the axis minimum. If it's been nudged above zero, by hand or by an auto-scale setting, every column's true height gets compressed and small real differences look identical. Reset the value axis minimum to 0.
Aprende más sobre el Column Chart
¿No estás seguro de que el Column Chart sea la opción correcta? Descubre qué es, cuándo usarlo y cuándo no.
Column Chart: preguntas frecuentes
Two columns and one header row: a category label, usually a time period, in the first column and one number per category in the second. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Crea tu Column Chart ahora
Gratis para empezar con más de 300 plantillas. No se necesita tarjeta de crédito.