Changing scale axis

The AxisChange routine would be in a standard code module and is cabable of handling the first chartobject on any sheet.

But the trick to getting it to work on multiple sheets is to add the Worksheet_Change code to each sheet that has a chart and cell information.

See revised example.