How to Sort Chart Data: Value vs Category vs Time
Most charting tools default to alphabetical sorting, and that default is almost always wrong: sort comparison charts by value so the ranking is visible at a glance, and sort time-series charts chronologically, never alphabetically or by value.
Quick answer: Sort bar charts and other ranked comparisons by value, descending, unless there's a natural category order (like a funnel's steps) that matters more than magnitude. Sort time-series charts chronologically, always. Alphabetical order should only be the choice when the categories genuinely have no other meaningful order, like a directory or reference list.
Why is alphabetical the default, and why is it usually wrong?
Alphabetical is the default because it's the easiest sort for software to apply automatically to a list of category names, not because it's meaningful to a reader. It puts "Alabama" ahead of "California" for no analytical reason, forcing the viewer to scan the entire chart to find the highest or lowest bar instead of reading it off the top or bottom.
When should I sort a chart by value?
Sort by value whenever the chart's purpose is ranking or comparison — "which product sold the most," "which rep is behind quota" — so the answer is visible without hunting. Descending order (highest first) matches how most people scan a ranked list, top to bottom or left to right.
| Chart purpose | Sort by |
|---|---|
| Ranking categories (top products, top reps) | Value, descending |
| Time series (revenue over months) | Chronological, always |
| Funnel stages | Process order, not value |
| Likert / survey scale responses | Scale order (strongly disagree → strongly agree) |
| Reference list, no inherent ranking | Alphabetical |
Why should time series never be sorted by value?
Sorting a time series by value destroys the one thing it exists to show — the trend over time — and turns it into a random-looking bar chart with dates as meaningless labels. Time is an ordinal axis with a built-in, non-negotiable order; a chart plotting January after August because August had a bigger number is unreadable.
What about charts with a natural process order, like a funnel?
Keep the process order (awareness → consideration → purchase) even though it isn't sorted by value, because the sequence itself is the finding — where does the biggest drop happen between adjacent steps. Sorting a funnel by value would hide exactly the step-to-step comparison the chart is built to show. See when to use bar charts for more on matching sort order to chart intent.
Common mistakes
- Leaving a BI tool's default alphabetical sort in place without checking if it's the right order for the chart's purpose.
- Sorting a comparison chart ascending, which puts the most important bar (the biggest) at the bottom or far right, where it's scanned last.
- Re-sorting by value on every data refresh, so category positions jump around between views and viewers lose their place.
- Sorting a small-multiples grid inconsistently, so panel order doesn't match across a report.
Pro Tip: When a comparison chart also needs to stay readable across refreshes (a live dashboard, not a static report), consider a fixed custom sort order instead of live value-sort — otherwise categories reshuffle position every time the numbers update, and regular viewers lose their mental map of where each one sits.
← Back to Visualization Tips