Chart help

[NGUSER]

Hi,

I need to automatically adjust the y-scale of graphs by setting the minimum of the y-axis to the minimum value of a range on the worksheet. I wrote code for the Worksheet_Change event, but now when the Chart gets updated, I can't undo the changes that I make to the range. Is there a way I can do the same thing but still have the Undo functionality?

Thanks!

 

[zzjasonzz]

as far as i know, changes made by macros can't be undone