specifying highcharts properties for the secondary axis of a dual-axis chart

Issue Description

A customer's dual-axis chart is showing values that are not in their desired range of scale. For example they have values ranging between 0 and 60 on the Y axis, but due to Highcharts default calculations it is beginning the low starting point for the range at -20.

Often the Highcharts property 'yAxis.min' will help limit or define the range, but a trick is required when you have a dual-axis chart

Resolution

yAxis.min, added thru Advanced Properties will only impact the first axis.  To impact the second axis, directly in the jrxml source, add an additional chartSetting element for the secondary axis using the following property to designate which axis you are referring to:

<hc:chartProperty name="_jrAxisIndex">

     <hc:propertyExpression><![CDATA[1]]></hc:propertyExpression></p>

See the attached .jrxml which runs against Studio's "sample DB" as an example.

For reference on the HighCharts yAxis.min property see: http://api.highcharts.com/highcharts#yAxis.min

Ref. Case 00069569

minforsecondaxis.jrxml