How to autoscale chart Y-Axis using VBA

[mrprofit]

a_Y-Axis auto scale.zip

How to autoscale chart using VBA, so i can maximize the viewable area without using the default format axis on chart each time i paste new data to the table,

Thank you

[LJMetzger]

Hi mrprofit,

The following Macros may help you.
Before you run the Macros you MUST click on a Chart to make it the Active Chart.
Runtime errors may occur if certain resources are not available (such as the secondary axis).
Comment out any line that causes a runtime error.

Lewis

Please Login or Register  to view this content.

[mrprofit]

Thank you for the help, how to make this code autoscale by data in a cell / range

Please Login or Register  to view this content.

[Andy Pope]

you can check the present of the axis before trying to read or write properties to avoid errors

Please Login or Register  to view this content.

[mrprofit]

Please Login or Register  to view this content.

is this the line to put it in?

[Andy Pope]

You need to include an end if

Please Login or Register  to view this content.