Scale For Secondary Axis of Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

I found code that can be used to edit the Maximum Scale of of the Primary Y
Axis of a graph, but I am having difficulty editing this code to change the
Maximum Scale of the Secondary Y Axis. Does anyone know how I can do this?

Here's the code...

Me![OLEUnbound0].Axes(2).maximumscale = Me![MaxScale]

Thank you!
 
Hi Justin
I think I have it figured out as I had the same issue, try
Me![OLEUnbound0].Axes(2,2).maximumscale = Me![MaxScale]

Dale
 
Thanks Dale...that works perfectly!

Dale said:
Hi Justin
I think I have it figured out as I had the same issue, try
Me![OLEUnbound0].Axes(2,2).maximumscale = Me![MaxScale]

Dale

Justin said:
Hello:

I found code that can be used to edit the Maximum Scale of of the Primary
Y
Axis of a graph, but I am having difficulty editing this code to change
the
Maximum Scale of the Secondary Y Axis. Does anyone know how I can do
this?

Here's the code...

Me![OLEUnbound0].Axes(2).maximumscale = Me![MaxScale]

Thank you!
Click to expand...
Click to expand...
 
Back
Top