Chart Group by

Hi there,
I want to present data in Graph by showing how many items exist from each category.
For example, there are 5 coffee type, 10 alcohol type, 3 energy drink type.
Data is saved in a database and each product belongs to a category. I want to display how many products of each category. Tried with repeat etc but with no success.

Thank you!