Make a bar chart race from Excel or Google Sheets

Updated 2026-08-08 · Chart Maker for Mac

Your sheet is already most of the way there. Here is the layout, the export, and the traps that come with spreadsheet files.

The Chart Maker editor on an iPad after importing a spreadsheet export
A spreadsheet export drops straight in: the template keeps its styling.

Lay the sheet out wide

Put one row per competitor and one column per point in time. Row 1 is the headings; column A is the name. If your data is currently long, one row per name-and-year pair, a pivot table turns it into this shape in about thirty seconds.

Cumulative or not?

For the classic “piling up over time” race, make the figures running totals. In Excel or Sheets that is one formula dragged across: =SUM($B2:C2) for the cell under the second year, and so on.

Leave the blanks blank

Do not fill empty cells with zeros to tidy the sheet. A blank means “not in the race yet”; a zero means “in the race with nothing”, and the second one parks a bar on the baseline from the first frame.

Export as CSV

Only the active sheet is exported, so make sure the one you want is in front.

What the importer sorts out for you

Spreadsheet exports are messier than they look, and the reader is built for the real ones rather than the ideal ones. It copes with semicolons or tabs instead of commas (which is what Excel writes in much of Europe and Latin America), with 1.234,56 as well as 1,234.56, with currency symbols, with Windows line endings, and with the byte order mark Excel puts at the front of a UTF-8 file.

Check the read, not the file

View data shows the numbers as the chart will receive them and lists which of your columns became the name, the picture, the flag code and the group. A decimal comma misread as a thousands separator is invisible in the chart, where it just looks like a very good year.

Questions

Can I import an .xlsx file directly?

Not today - save or export it as CSV first. Every spreadsheet app does it in two clicks.

My accented names came out wrong. What happened?

The file was not saved as UTF-8. Re-export it choosing CSV UTF-8; the app warns you when it has had to fall back to Latin-1.

Make one from your own data

A native Mac app. Free to download, free to export at full resolution, one payment to remove the mark.

Download on the App Store