apex_add_stacked_chart
Add a stacked bar or area chart to an Oracle APEX page. Define up to 10 SQL series to display values by label with custom axes and colors.
Instructions
Add a stacked bar/column chart. SQL: LABEL, VALUE, SERIES.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels (default 380). | |
| labels | No | Optional dict of localised labels (currently unused for this chart type, reserved for future use). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| chart_type | No | "bar" (vertical stacked bars, default) or "area" (stacked area). | bar |
| region_name | Yes | Region display name. | |
| series_list | Yes | List of 1–10 series dicts, each with: - "name": Legend label for this series - "sql": SQL returning LABEL (X-axis) and VALUE (Y-axis) columns - "label_column": X-axis column name (default "LABEL") - "value_column": Y-axis column name (default "VALUE") | |
| x_axis_title | No | X-axis label. | |
| y_axis_title | No | Y-axis label. | |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| color_palette | No | List of hex colours, a named palette string, or None for default colours. | |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |