Secondary Y-Axis Chart overlay above Primary Y-Axis Plot

Hi,

I have an issue with the chart display when overlay's are added to secondary Y-Axis.
Please find the attached screenshot attached "ChartOverlay.jpg". It contains Seconday Y-Axis Values which are displayed over the Primary Y-Axis Area. Is there a possiblity to set something somewhere in the chart; such that the Secondary Y-Axis values are displayed over (away) from the primary Y-Axis shading. I just copied from the screenshot about the current requirement. I tried different mechanism like stacking, but no luck.
Please configure the attached design file to access mysql and the data.txt table contains sql for inserting data into the table tt.

Many Thanks!!
Aj

Find more posts tagged with

Comments

mwilliams

Where the secondary axis values are placed all depends on your axis scale. If you were to make the scale -200% to 200%, the values are all above the shaded area. This is no a very dynamic approach, but it may work for your application. If you didn't want to see the negative y-axis values caused by this, you could hide the labels for values less than 0.

Hope this helps.

ATirumalas

Though a bit reluctant to hard-code the range, I am happy to live with this at the moment. Please let me know if you do come up with any alternatives.

Thanks Guru!!

mwilliams

You could possibly set the scale for y-axis 1 to twice the value that you actually need. This would leave the top half of the chart empty. You could then dynamically set your scale for the y-axis 2 to have an even range of negative to positive values i.e. -200 to 200 or -150 to 150. Then, any positive percentage would be above the chart. Or something similar to this. That would just make the same thing, just more dynamic. I haven't tried this yet, so let me know if you run into issues if you try it and I'll give it a go.

ATirumalas

Your idea worked great. That's a brilliant idea.
Unfortunately (for the actual report) I do not know the Y-Axis1 max value either, its a dynamic value and varies quite drastically based on selected parameters for the actual report. I think I should be able to live with this for now. Many Thanks for your help.

mwilliams

Ok. Let me know if this comes up as an issue again!

sivagv1

Hi williams,
 
This solution really gave me an idea to solve my issue, but I am stuck at this point. I would like to know, how can I double the scale for Y-axis if it is a dynamic value in Actuate e-report designer.

Clement Wong

e. Report Designer? You'll need to contact your local Support Group (<a data-ipb='nomediaparse' href='http://www.actuate.com/resources/support/global-support-centers/'>http://www.actuate.com/resources/support/global-support-centers/</a>) for this issue. These forums are for OS BIRT, commercial BIRT, iServer, and iHub related only.