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 EBS R12 General Ledger (GL) Module – Practical SQL Queries

Introduction Oracle E-Business Suite (EBS) R12 General Ledger (GL) is the core Financial module in Oracle EBS R12. It is used to manage journal entries, accounting periods, balances, and financial reporting. The GL module integrates with Payables (AP), Receivables (AR), Fixed Assets (FA), Purchasing (PO), and Inventory (INV). The main purpose of a general ledger system is to record financial activity of a company and to produce financial and management reports to help the organization make decisions. Below are real-world SQL queries commonly used.   1) View configured Ledgers      Purpose: Fetch Ledger Configuration Details SELECT       ledger_id,      name  AS   ledger_name ,    short_name ,   currency_code FROM     gl_ledgers ORDER BY     ledger_id ;   2) Ledger Information Query Purpose: Fetch Ledger Configuration Details SELECT     gl.name   ...
Post a Comment
Read more

Exploring AI in Oracle APEX 26.1

Artificial Intelligence (AI) is transforming the way organizations and developers work. Businesses and professionals are increasingly adopting AI tools to improve productivity, automate processes, and build smarter applications. Oracle APEX introduces a significant evolution in application development by integrating governed Generative AI capabilities directly into the low-code platform. This enables developers to build intelligent, conversational applications while maintaining enterprise-grade security and control. In this article we explore AI capabilities in Oracle APEX 26.1 What is AI Agents AI Agents can be created to reason over user requests and take actions through approved AI Tools. Each tool exposes a specific application capability the agent is allowed to invoke, such as retrieving data, running server-side PL/SQL, or executing client-side JavaScript. APEX manages the execution flow by preparing context, dispatching tool calls, executing tools, handling results, and...
Post a Comment
Read more

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