Hi,
find an empty cell in your sheet and calculate what the maximum axis value should be. Give this cell the range name Ymax
For good measure, you can also define cells for Ymin, Ymajor and Yminor. If you don't want these, just delete the respective lines in the code below.
Then add a button to the sheet and assign it this macro
You need to check the name of your chart and correct it in the macro, if required. To find the name of your chart, click outside the chart, then hold down the Ctrl key and click the chart. Now the chart name will be displayed in the name box above cell A1
hth
Bookmarks