Course / Charts

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

  1. 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.

  2. Now chart the sorted table. Select D1:E8, click Chart, choose Bar, and click Insert.

  3. Give it a title: under Chart title in the Chart panel, type Support tickets by reason.

  4. Say what the numbers along the bottom are. Under Horizontal axis title, type Tickets.

Remember

In the function reference: SORT

Previous: Your first chart · Next: Line charts for trends