With VBScript, I'm using
<object id=ChartSpace1
classid=CLSID:0002E500-0000-0000-C000-000000000046></object>
I create two series and add another y axis.
ChartSpace1.Charts(0).Axes.Add
ChartSpace1.Charts(0).Scalings(c.chDimValues), c.chAxisPositionRight,
c.chValueAxis
The problem is when I change the scale of the c.chAxisPositionLeft axis,
ChartSpace1.Charts(0).Axes(c.chAxisPositionLeft).Scaling.Maximum = 105
it automatically changes the scale of the c.chAxisPositionRight axis and
vica-versa.
Is there any way to have a different scale for each y axis?