Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

charts with multiple y axes not working in APEX 4.1

Deb.GroskreutzSep 1 2011 — edited Sep 1 2011
I've been waiting for the APEX 4.1 upgrade to be able to use the multiple y axis functionality without having to jump through a lot of hoops. As I read that this would all be fixed in 4.1. (Thank you for this release!! Awesome!)

However, I've run into the following problem with the multiple Y axis chart:

I'm trying to show actual counts on one Y axis and the % on the other Y axis. When I try to do a multiple axis chart, the axes ranges on both y axes initially display the same scale. Then, when I customize the XML for the first axis to have a minimum="0" and a maximum="100", then the second serires starts ignoring the second axis altogether, using only the first axis, so I'm back where I started with how it worked in APEX 4.0.

For example, you can repeat the problem this way:

1) Create a 2D bar chart, with the following 2 series queries:

Series 1:
select null link,
'test' label,
1,2,3
from dual;

Series 2:
select null link,
'test' label,
100,200,300
from dual;


Click the multiple Y check box and run it.

Both axies have the identical scales 0-350, and 6 vertical bars are displayed

Then, I edit the XML within the chart to set the first y axis scale to maximum="100" minimum="0" (my representative % calculcations)

But, when I do this, the Series 2 values stop respecting the second y axis and instead now go off the chart!

Can anyone help me with this? Is there a fix or a work-around? Or maybe,hopefully, I'm just doing something wrong?
Also, is there any way to make the Series 1 and Series 2 scales show the appropriate ranges for each axis from the start?

Thank you for your time.

Deb G
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2011
Added on Sep 1 2011
2 comments
697 views