Sample CSV
| Department | Headcount |
|---|---|
| Engineering | 84 |
| Sales | 52 |
| Customer Support | 37 |
| Marketing | 29 |
| Finance | 18 |
| Operations | 15 |
How to Create a Bar Chart
A step by step walkthrough for turning a spreadsheet into a published bar chart in PlotSet, from shaping the sheet to exporting or embedding the finished chart.
About 6 minutesBy the end of this guide you will have a published, interactive bar chart built from your own spreadsheet: sorted, labelled, coloured on purpose, and either embedded on a page or exported as an image for a deck. Not a screenshot of someone else's example, your own categories and your own numbers, going through the same click path a real PlotSet chart takes from upload to publish.
If your spreadsheet is already in two columns, category and value, this takes about five minutes. Add ten more if you are still cleaning up a messier export: merging duplicate category names, deciding what to do with a stray blank row, or pulling one column out of a wider report. Budget the six minutes below and treat the rest as a buffer.
The data you need
Two columns, one row per category: the category name first, the number second. No totals row, no merged cells, one header row.
Keep the category column as plain text. If a spreadsheet turns "Q1" or a department code into a date or a formula result, PlotSet will chart the underlying value, not the label you intended.
One number per category. If you are tracking a category across several time periods, that is a grouped or stacked bar chart, not this one: see the grouped bar chart guide for the extra column that setup needs.
Delete any totals or subtotals row before uploading. A "Total" row uploaded as data becomes a bar of its own, usually the tallest one, and throws off the sort.
Blank cells in the value column render as zero-length bars rather than being skipped. Fill them in or remove the row.
The steps
The exact click path in PlotSet, from a blank template to a finished chart.
- 01
Open the bar chart template
From the PlotSet dashboard, start a new project and choose the Bar Chart template. It loads with sample data already in place so you can see the exact column layout PlotSet expects before you touch your own file.
Every guide starts here. Pick the category, then the template: it is the same grid whichever chart type you are after. - 02
Shape your sheet into two columns
Put the category name in the first column and its number in the second, one row per category. If your source data is a pivot table or a report with subtotals, strip those out first: the upload should be nothing but categories and values.
- 03
Upload your file or connect a sheet
Use the data panel to import a CSV or .xlsx file, paste rows directly from a spreadsheet, or connect a Google Sheet if you want the chart to pick up edits later without a re-upload. PlotSet reads the first row as headers automatically.
The data view, shown here on a bar chart project. Upload a CSV, lift the numbers out of an image with Magic Import, or sync a Google Sheet. The panel is identical for every chart type. - 04
Map the category and value columns
Confirm which column feeds the category axis and which feeds the bar length. This is usually automatic when your headers are clear, but check it manually if your sheet has extra columns PlotSet might have guessed wrong on.
Bindings decide which column becomes the label, which supplies the values and which drives the colour. Auto Binding guesses them from your headers, so check it rather than assume it. - 05
Sort the bars
Switch the sort to descending by value unless your categories already have a natural order, such as age brackets or survey ratings. A sorted chart shows the ranking at a glance; an unsorted one makes the reader hunt for it.
- 06
Add value labels and drop the gridlines
Turn on labels at the end of each bar so the exact number is readable without measuring against the axis. Once every bar carries its own number, the background gridlines are usually redundant and the chart reads cleaner without them.
- 07
Pick one colour and a title
With a single series, one consistent colour is correct: colour is not carrying any information here, so a rainbow of bar colours only adds visual noise. Save a second colour for a highlight if you want to draw attention to one specific bar. Add a chart title that states the comparison, not just the metric.
The Preview tab for a Bar Chart. Every styling control lives in the outlined panel, each on its own tab: appearance, header, footer and the options specific to this chart type. - 08
Publish, embed or export
Publish for a live, interactive chart with hover tooltips and a shareable link, grab 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 a report.
Start from the Bar Chart template with sample data already loaded, then swap in your own.
Open the templatePublish, embed or export it
The last stretch is the same for every chart type: Share turns the chart into a live public link and an embed code, Export writes it out as a static file.
Share: public link and embed code
Activating the embed code and public link publishes the chart. The link is safe to send to anyone, and the embed code drops into any page as an iframe that keeps the hover tooltips and the interactivity. Edit the chart later and hit Recreate to push those changes out to both.
Export: SVG, PNG or JPG
Export writes a static copy at whatever size you need. SVG stays sharp at any scale and can still be edited in a design tool; PNG and JPG are the safe choices for slides and documents. The scale multiplier is what gets you a crisp image on a retina screen.
Styling tips for a Bar Chart
Horizontal bars for long category names
If your categories are anything longer than a short code, department names, product names, survey questions, keep the chart horizontal. Long labels get a full line each with no rotating or truncating, which is the main reason to reach for a bar chart over a column chart in the first place.
Start the value axis at zero, always
Bar length is the encoding, so a truncated axis exaggerates every gap on the chart. If you are tempted to zoom in on a narrow range of similar values, add value labels instead and leave the axis at zero.
Cap it around twenty five bars
Past roughly twenty five categories, a bar chart turns into a wall of thin lines nobody can compare. Filter to your top group (top 10, top N by region, whatever the story actually needs) and mention in the title or a caption that it is a subset.
Reserve colour for one comparison at a time
If you do need a second colour, use it for exactly one thing: the category you are calling out, or a threshold like "above target" versus "below target." Two colours used for one clear reason read better than four colours used for none.
Common mistakes when making a Bar Chart
The bars come in alphabetical order, not ranked
This means the sort setting is still on the default (usually by category, not by value). Open the sort control in the chart settings and switch it to sort by the value column, descending.
One bar is far taller than the rest for no obvious reason
Check the raw data for a totals or subtotals row that got uploaded along with the real categories. Delete that row from the source sheet and re-upload, or remove it directly in PlotSet's data table.
A category is missing or merged with another
This usually means two rows in the source spreadsheet had category names that differ only by trailing spaces, capitalization or a stray character. Clean the category column in your spreadsheet (a TRIM formula catches most of it) before re-uploading.
Learn more about the Bar Chart
Not sure the Bar Chart is the right choice? See what it is, when to use it and when not to.
Bar Chart: common questions
Two columns and one header row: category names in the first column, one number per category in the second. CSV and .xlsx both work, and a pasted range from any spreadsheet tool is fine too.
Make your Bar Chart now
Free to start with 300+ templates. No credit card required.