All Apps and Add-ons

Dual Y Axis with different scales

Path Finder

Hi -
I want to graph 2 data points against each Y axis (left & right). I would like the scales of the 2 data points to be different . Currently I can graph 2 data points against each Y axis however the scale is the same.

Here is the output:
dl.dropboxusercontent.com/u/2723331/Screen%20Shot%202013-10-24%20at%205.21.16%20PM.png

Here is the charting parameters being used.

<module name="HiddenChartFormatter">

  <param name="charting.legend.placement">top</param>
  <param name="charting.axisX">time</param>
  <param name="charting.axisTitleX.text">Time</param>

  <param name="charting.data1">view</param>
  <param name="charting.data1.table">@data</param>
  <param name="charting.data1.columms">[0,1]</param>
  <param name="charting.chart.data">@data1</param>

  <param name="charting.data2">view</param>
  <param name="charting.data2.table">@data</param>
  <param name="charting.data2.columms">[0,2]</param>
  <param name="charting.chart2.data">@data2</param>

  <param name="charting.chart">line</param>
  <param name="charting.axisY">numeric</param>
  <param name="charting.axisTitleY.text">VLTs</param>
  <param name="charting.axisLabelsY.placement">left</param>

  <param name="charting.chart2">line</param>
  <param name="charting.chart2.axisY">@axisY2</param>
  <param name="charting.axisY2">numeric</param>
  <param name="charting.axisY2">@axisY</param>
  <param name="charting.axisLabelsY2">#axisLabelsY</param>
  <param name="charting.axisLabelsY2.axis">@axisY2</param>
  <param name="charting.axisLabelsY2.placement">right</param>
  <param name="charting.axisTitleY2">axisTitle</param>
  <param name="charting.axisTitleY2.text">EGTs</param>

  <param name="charting.layout.charts">[@chart,@chart2]</param>
  <param name="charting.layout.axisTitles">[@axisTitleX,@axisTitleY,@axisTitleY2]</param>
  <param name="charting.layout.axisLabels">[@axisLabelsX,@axisLabelsY,@axisLabelsY2]</param>

Further troubleshooting led me to discover that both columns/data points are being plotted on the primary Y axis despite "[0,1]". I am still not sure what the solution is.

Thanks,
Joe

Path Finder

ARGH... s/columms/columns/

Now it works as expected.

    <module name="HiddenChartFormatter">
  <param name="charting.legend.placement">top</param>
  <param name="charting.axisX">time</param>
  <param name="charting.axisTitleX.text">Time</param>

  <param name="charting.data1">view</param>
  <param name="charting.data1.table">@data</param>
  <param name="charting.data1.columns">[0,1]</param>

  <param name="charting.data2">view</param>
  <param name="charting.data2.table">@data</param>
  <param name="charting.data2.columns">[0,2]</param>

  <param name="charting.axisY2">#axisY</param>
  <param name="charting.axisLabelsY2">#axisLabelsY</param>
  <param name="charting.axisLabelsY2.axis">@axisY2</param>

  <param name="charting.chart.data">@data1</param>
  <param name="charting.chart">line</param>
  <param name="charting.axisY">numeric</param>
  <param name="charting.axisTitleY.text">VLTs</param>
  <param name="charting.axisLabelsY.placement">left</param>

  <param name="charting.chart2.data">@data2</param>
  <param name="charting.chart2.axisY">@axisY2</param>
  <param name="charting.chart2">line</param>
  <param name="charting.axisY2">numeric</param>
  <param name="charting.axisTitleY2.text">EGTs</param>
  <param name="charting.axisLabelsY2.placement">right</param>
  <param name="charting.axisTitleY2">axisTitle</param>

  <param name="charting.layout.charts">[@chart,@chart2]</param>
  <param name="charting.layout.axisTitles">[@axisTitleX,@axisTitleY,@axisTitleY2]</param>
  <param name="charting.layout.axisLabels">[@axisLabelsX,@axisLabelsY,@axisLabelsY2]</param>