Skip to main content

Oracle APEX: Displaying Multiple Data Series in Bar Charts

 Introduction

When building data-driven dashboards in Oracle APEX, it is common to need more than one data series on a single bar chart. In our scenario we want to compare ordered quantity against receipt quantity for each supplier, side by side, in the same chart.

This article guides how to add a second series to an existing bar chart in Oracle APEX, configure its data source, and customize the color of each series for clarity.

Prerequisites

  • A page in Oracle Apex Application containing a Bar Chart region
  • At least one series already configured on the chart (in our example Ordered Qty. mapped to the Order Qty. column.

How to Add a Second Series to a Bar Chart 

Step 1: Open Page Designer

Navigate to your application in Oracle APEX and open the relevant page in Page Designer.



Step 2:  Locate and Expand the Chart Region

In the left-hand rendering tree, find your existing Chart region and click the arrow next to it to expand it. You will see its child components, including any existing series beneath it.

Step 3: Add a New Series

Right-click on the Chart region in the rendering tree. From the context menu, select:

1.      Right-click the Chart region

2.      Select Create > Series

A new series entry will appear as a child of the Chart region in the rendering tree.

Step 4: Configure the New Series

Click on the newly created series to select it. In the right-hand Properties panel, configure the following settings:

  Under the Identification section:

•        Name: Receipt Qty

Under the Column Mapping section:

•        Label: SUPPLIER

•        Value: RECEIPT_QTY

Once saved, run the page. Both series will now appear together on the bar chart, displayed side by side for each supplier.

 

Customizing Series Colors

To make the chart easier to read, assign a distinct color to each series:

     1.      In Page Designer, expand the Chart region in the rendering tree.

2.      Click on Series 1 (e.g., Ordered Qty) to select it.

3.      In the Properties panel on the right, scroll to the Appearance section.

4.      Locate the Color property and either pick a color from the palette or enter a hex code directly (for example, #4472C4 for blue or #ED7D31 for orange).

5.      Repeat the same steps for Series 2 (e.g., Receipt Qty), choosing a contrasting color.

6.      Save your changes and run the page.

 

The completed chart will now display both series with distinct, customized colors, making it straightforward for end users to distinguish between ordered and received quantities at a glance.

 
 Conclusion

Adding multiple series to a bar chart in Oracle APEX is simple. By right-clicking the Chart region and selecting Create Series, you can layer as many data series as your query supports. Customizing the color of each series makes the chart easier to read and more visually informative for end users.

This pattern can be applied to any chart type in APEX that supports multiple series, such as line charts and combination charts.

 

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

Oracle R12 Inventory Configuration: Key points to Avoid Mistakes

Most Oracle ERP R12 inventory problems are not system failures they are process and configuration failures. The same categories of mistakes surface repeatedly across implementations: Focusing on master data control, disciplined transactions, proper OU setup, and strong internal controls prevents operational and financial discrepancies.   This article walks through the four most critical areas where Oracle R12 inventory implementations go wrong, explains why each mistake is costly, and provides recommendations to prevent them. Each section includes the relevant navigation path and configuration screenshots for hands-on reference   1.       Improper Item Master Configuration in Oracle R12   Oracle E‑Business Suite R12 , the Item Master Configuration serves as the foundation of the Inventory module. Two critical components under this configuration umbrella are: Define Master Item Setup Define Item Status Both setups control how items ...
Post a Comment
Read more

Monitoring and Troubleshooting Oracle APEX Performance with Real-World SQL Queries

    Introduction Oracle Application Express (APEX) is one of the most widely adopted low-code development platforms in the Oracle ecosystem. As organizations scale their APEX deployments, the need for robust monitoring and troubleshooting capabilities becomes critical. This article provides SQL queries that DBAs and developers can use to monitor, diagnose, and optimize their APEX environments.   What makes monitoring APEX unique is the three-tier architecture it operates on: the Oracle Database at the data layer, APEX at the application layer, and Oracle REST Data Services (ORDS) as the middleware. Understanding how sessions flow through these three layers is the key to effective monitoring.     Architecture Overview   Layer Component Version Role Database Oracle DB 19.28 Stores data, executes SQL, manages sessions Application Oracle AP...
Post a Comment
Read more
SQL Query Performance Tuning: A Practical Approach for Oracle DBAs Inefficient queries in Oracle Database can significantly impact system performance, resulting in higher response times and decreased user productivity. By closely monitoring memory usage and CPU consumption, database administrators can identify performance bottlenecks and determine the root causes of inefficient query execution. Oracle Query Performance Tuning Checklist 1.          Monitor Memory Usage:                Purpose: Ensure optimal memory allocation to prevent excessive disk I/O and performance degradation.             Actions: * Track memory consumption using Oracle Enterprise Manager *Automatic Workload Repository (AWR) reports to review SGA and PGA utilization, and identify abnormal memory usage patterns. Analyze AWR reports for: a.   ...
Post a Comment
Read more