Charts are based on Oracle JavaScript Extension Toolkit (JET) Data Visualizations.
For more examples, please install the Sample Charts from Packaged Apps > Sample Apps.
Set Chart as Region type and provide SQL query. In Region attributes, select a type out of 15 types, e.g. "Bar".