You Asked
I have a problem generating the vertical lines in a line chart. E.g. take this query:
with nums as (
select rownum as rnum
from dual
connect by rownum < 300)
select rnum/9 as x, sin(2*rnum/30) as y from nums
In the X-Axis, my tick markers, have decimal values. I would like to have vertical lines on x-Axis values 1,2,3,4 etc, or maybe 2,4,6,8,... I don't manage to get control over this, they always come at .1111111 .666666 1.222222 etc... no matter what I specify in the graph settings. How to specify exactly the interval for the markers on the X-Axis?
and we said...
<p>Hi Geert,</p>
<p>Thank you for taking the time to post your chart question, and I hope you found yesterday's session helpful. As we are actively discussing this query via the OTN forum,
https://community.oracle.com/thread/4167801, hopefully my suggested alternative of using a Scatter chart type will resolve the issue for you. I will need to reach out to the JET team in relation to the behaviour of the x-axis Step, Minimum Step and Major Step attributes on a numeric x-axis value.</p>
<p>Thank you again for posting your question.</p>
<p>Regards,</p>
<p>Hilary</p>