Bar charts for long names
Sort a list with a formula, chart it as horizontal bars, and label the axis. Beginner · 5 min · Bar chart, SORT, Axis title
A bar chart is a column chart turned on its side. The bars run across, so the names sit on the left where there is room to read them.
Use it when the names are long, or when there are many of them. Under a column chart, names like these would overlap or be cut short.
A bar chart reads best in order, longest bar first. A chart draws the rows in the order they are in the sheet, so the sorting happens in the data, before the chart.
Steps
First put the reasons in order. In
D2, list them from most tickets to fewest with=SORT(A2:B8, 2, -1): sort by the 2nd column, largest first.Now chart the sorted table. Select
D1:E8, click Chart, choose Bar, and click Insert.Give it a title: under Chart title in the Chart panel, type Support tickets by reason.
Say what the numbers along the bottom are. Under Horizontal axis title, type Tickets.
Remember
- A bar chart suits long names and long lists: the names get a whole line each.
- Charts draw rows in sheet order. Sort the data first, with
SORTor by hand. - An axis title says what the numbers are: tickets, dollars, hours.
In the function reference: SORT
Previous: Your first chart · Next: Line charts for trends