It would have to be with programmatic support. For a ready-made
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...
Dear all,

I have a chart with on the X-axes the age of a person until his retirement
age.

My problem is now: how can I start my excel chart with a starting age of 25
till retirement (65) for a certain person, but when I take another person my
chart have to start with starting age 45, I will get a chart starting from 45
till 65. So I want to change my starting point depending on the person.

Best regards,
Jan