Your answers will display alphabetically by default. You can change this in the "Group order" datasheet. For the example below, you might prefer to show groups for Yes, No, and Answer not supplied in that order.
To do this,
- 1
-
Go to the “Group order” data sheet, and fill in the heading of column A with the column name of the relevant question in the “Data” sheet
- 2
-
Underneath, type or paste in the answer values in the order that you'd like them displayed
- 3
-
Then, in the column settings panel, make sure “Order of answers” points at column A
- 4
- You can repeat this for as many columns as necessary. Group the below example by "Has a drivers license" to see the result!