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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to apply the same Fixed Horizontal Scale to Both Vertical Axis 0
Converting to Log scale with primary and secondary y axes 2
Additional secondary axis scales 0
Secondary X-Axis is mirror of Primary X-Axis 0
Chart - Secondary Y-axis with different values/scale 2
Ungrouping a series to use a secondary axis (OWC 9.0) 0
Excel: secondary Y axes with log-scale X axis 1
How do I add a data series in a combination chart in PPT 2003? 2

Top