Dynamic x-axis chart

Okay.. thx for the heads up.

Defined name formula revised as :-

Formula:

=OFFSET('Individual Metrics'!$K$7,MATCH('Individual Metrics'!$K$2,'Individual Metrics'!$K$8:$K$19,0),0,MATCH('Individual Metrics'!$K$3,'Individual Metrics'!$K$8:$K$19,0)-1,1)

should work now, see attached:-
Example(1).xlsx

Regards,
DILIPandey
<click on below * if this helps>