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.