I don't know your background nor the versions of Oracle and APEX you have.
Have you done simple charts like these?
COUNT(YOUR_COLUMN) AS YOUR_COLUMN
GROUP BY YOUR_COLUMN
ORDER BY 2
That the syntax for a chart, hope is helpful
Thank you howard.
Your 3rd document helped to me.