Programatically controlling scales on charts

N

Nick H

Hello,

I have been able to set scales on the left hand chart
axis by using the syntax me!
[chartname].object.application.chart.axes(2).MinimumScale
= cdbl(10)

However, I am using a chart with two y axis, one on the
left and one on the right. The one on the right is called
a secondary value axis. Does anyone know the syntax to
set that one's scale?

Rgds Nick
 

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

Custom Format numbers for learning chart 0
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
vertical scale on both ends of bar chart 1
different value for setting with breakpoint vs regular running code 2
Chart - Secondary Y-axis with different values/scale 2
Adding a line to a population bar chart 0
Chart SeriesCollection Names 2
Chart Macro Help Needed 1

Top