-
Book Overview & Buying
-
Table Of Contents
Oracle Application Express 3.2 - The Essentials and More
By :
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 format...
Change the font size
Change margin width
Change background colour