Automatic Change of X-axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
if these are different charts for each person create an xy scatter chart.
with correct x axis. rightlcick x axis and click format axis choose x axis
and change the minimum and maximum to suit you
 
Back
Top