CODEWITHSUNDEEP
oracle-apexoracle-apex-19.1
Saddam Meshaal
Saddam Meshaal

Reputation: 552

How To Change Oracle Apex Chart Type Programmatically

I have a simple Chart Region: with

Static ID: Chart_Region

Attribute Type: Pie

Chart Serie: Salary Chart

Sql Query: Select Department_id, Sum(Salary) Sum_Sal From Employees Group by Department_Id;

Column Mapping: Label: Department_ID , Value: Sum_Sal and Static ID: Chart_ID

Simply I want to enable the end user to change the Chart Type: Pie to Type: Bar at the runtime (using toggle buttons that I have added). Any Idea please !.

Thank you in advance.

Upvotes: 0

Views: 1837

Answers (1)

Saddam Meshaal
Saddam Meshaal

Reputation: 552

I found it with Javascript like so:

apex.region('Chart_Region').widget.ojChart({type:'bar'});

and

apex.region('Chart_Region').widget.ojChart({type:'pie'});

available values for type are:

area, bar, boxPlot, bubble, combo, funnel, line, lineWithArea, pie, pyramid, scatter, stock

Upvotes: 1

Related Questions