Charts

Often, data can be better represented visually instead of being listed in a table. APEX provides chart regions that can be used to render charts on a page. APEX provides many different chart types including pie, bar, and line types that can be displayed in 2D and 3D formats. Charts in APEX can also render a single or multiple series of data.

Charts have many similarities to report regions, in that multiple charts can be placed on a page, and a wizard can be used to guide us through the process of creating a chart. Charts can also be parameter driven and able to drill down to other pages. This makes them very useful for dashboards and other types of interactive pages.

A chart region can be added to a page by using the add region icon on the Page Definition screen. From here, we can create a chart region and specify the type of chart. When creating a chart, the SQL query is the most important property we need to define. The SQL query used for the chart needs to be in the following...