Why most bar charts use the wrong default sort
Published
The default fail
Open Excel, paste a two-column dataset, click "Insert chart." The chart is in input order. Open Google Sheets, do the same — input order. Open Tableau or Power BI — input order, unless you spent a few minutes telling them otherwise. Almost no chart tool defaults to descending sort. As a result, most bar charts in business decks are in input order, which is almost always the order someone happened to type rows into a spreadsheet.
What input order communicates
Nothing. The reader has to scan every bar and rank them mentally. The chart has failed at the one job a chart should do: making comparison effortless. Sorting descending puts the answer at the top of the chart, where the eye lands first.
When input order is fine
When the input order is itself meaningful: chronological for months, scale order for Likert ratings, alphabetical for directories. In those cases, the input order isn't arbitrary; it's the natural order of the data, and breaking it would lose information.
Reframing with sort
Sometimes changing the sort changes the chart's message. A grouped bar chart of NPS by team, sorted by total responses, looks like a chart about team size. Sorted by NPS, it looks like a chart about quality. Same data, different chart. The sort is part of the editorial decision, not just a display preference.
A small protest against tool defaults
Charting software could default to descending sort with a one-click toggle to revert to input order. The current default — input order — silently produces worse charts and trains people to accept them. If you're building a chart tool, change the default.