VBA to set Minimum and Maximum Values of X Axis

Hi.

I have a chart which on X Axis has date values and Y Axis has effort (in man-hrs).
I want to set the minimum and maximum values of the X-Axis as the first and last date in the chart data.
Can you please help with VBA code to set these dynamic minimum and maximum X-Axis values.

Any help would be appreciated.

Andy , this code doesn't seem to work for me

Attaching my worksheet with the timeline I had prepared using XY Scatter Chart.I am writing the below code but when executed , it gives weird results -blanks out the entire chart

Below is the code.

Please Login or Register  to view this content.

Please help.

Thank you so much , it worked..Appreciate your help