You have to do this programmatically. For a readymade solution see
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I want to update the min and max box of the Value (X) axis scale without
having to click on the axis, select the tab and type in the min and max times
for each scale for each chart.
Can I assign a cell in the spreadsheet so that its value will be used in the
min and max boxes?

Does anyone have a suggestion on how to best accomplish this?

Thanks,