OWC 9.0 - Changing Scale on secondary axis

W

whasp

Hi,

I am struggling to see how to change the scale of the secondary axis.
I have tried the following only to discover it changes the secondary
axis as well as the primary axis...

<code snip>
'Add axis
objCharts.Axes.Add objCharts.Axes(ChaCon.chAxisPositionLeft).Scaling,
_
ChaCon.chAxisPositionRight, ChaCon.chValueAxis
'Set scale
objCharts.Axes(ChaCon.chAxisPositionRight).scaling.maximum = 100

<end code snip>
I am at a loss ....
Any help will be greatly appreciated.

Cheers

Peter
 
Top