Automatic change in axis scale

This should teach you everything you need to know: http://peltiertech.com/link-excel-ch...lues-in-cells/

When I click on "debug", it highlights the "ActiveChart" with statement. This suggests to me that it is not recognizing what "activechart" is. I would suggest that you assume that the chart is not "active" and designate the chart in a less ambiguous way. Can I assume you are familiar with the Excel object model, so that you can find your through the hierarchy of objects and collections to designate a chart? If needed, you might review the Excel object model: https://msdn.microsoft.com/en-us/lib.../ff194068.aspx In particular, look at the ChartObjects object/collection.

Start with its parent object, then work through the objects and collections. As I suggested, in particular, you will want to be familiar with the chartobjects() collection. If you did not follow the link to the chartobjects object and look at the examples there, then I strongly encourage you to do so. Recognize that VBA is an "object oriented" language, so understanding the Object model is a very important part of learning the programming language and learning how to interact with Excel.

Perhaps Activesheet will be reliable enough (ActiveSheet.ChartObjects(1).Chart.Axes.....)
When I need something absolutely unambiguous, I will often use the ThisWorkbook object (Thisworkbook.sheets(...).chartobjects(...).etc.