charts with multiple y axes not working in APEX 4.1
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