I have a spreadsheet that is filled by a form.
It contains values like the following:
Timestamp Person Category 2012-02-13 10.31.22 a x 2012-02-13 11.06.37 b y 2012-02-13 11.34.32 c x 2012-02-14 09.22.35 d z 2012-02-14 09.24.01 e w 2012-02-14 11.06.20 f x 2012-02-14 22.39.33 g y
I would like to make a bar chart that shows a bar for each category with the value of the number rows per category.
Should I calculate new columns in a new table before creating the chart, or could it be done in one step? And how?