I need the chart to be in order from the largest columns to the smallest, like a ladder. Anyone have any suggestions?
Create another table into your spreadsheet. For example with the QUERY expression you can sort the order dynamically. Then use that data as a source for your chart view.
Thayou Aleksi. That’s great, but i want this happen automatically because all the date should be change every day.
Have another tip?
The query formula will do that.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |