I've got a worksheet with five embedded XY-scatter plots. The first one is the "main" chart and I've got a macro that copies the y-axis scale settings of the first one onto the other four. Right now the macro is triggered via a button, but I was wondering if there is a way to trigger it via a chart event. Specifically, I was wondering if there is a way to run the macro whenever a change is made to the scale of the y-axis in the first chart. From what I can tell, all chart events with the exception of 'Calculate' are triggered before any changes occur, and the 'Calculate' event isn't much use since it's only triggered when the series data changes.

Does anyone have any suggestions of a workaround or are we stuck with using the button?

Thanks!