Hi,

The same way only you need to reference the secondary axis.

With ActiveChart.Axes(xlValue, xlSecondary)
.MaximumScale = 6
' Constant value
.MinimumScale = dYmin
' VBA variable
.MajorUnit = ActiveSheet.Range("A1").Value
' Worksheet range value
End With

Cheers
Andy

Read mo
http://peltiertech.com/Excel/Charts/...#ixzz0nbeBaxVT


On 11/05/2010 03:07, PYO1012 wrote:
How would you do this with a secondary axis? My issue is I have 2 Y axes and
I want them both to adjust relative to each other based on the data. I know
I can manually change the maximum values, but I would rather change the value
in which the 2 axes relate and have the charts adjust accordingly.

For example, 6 on the primary axis will equal 1 on the secondary, 12 will be
2, and so on. If I need to adjust it to, say 5 and 1, how could I accomplish
that without manual chart adjustments?

Phillip

"Andy Pope" wrote:

Hi,

See Jon's information
http://peltiertech.com/Excel/Charts/...nkToSheet.html

Cheers
Andy

Vince F wrote:
Since I got instant help on my last query, is there any way to use a cell
reference as an axis minimum or maximum in format axis? It seems impossible,
but there is a lot of experience out there. Thanks in advance.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info