Sometimes you may need to change the date on an axis to a specific day / month, you may use the following method:

• Click on the axis > Format axis, select General for the Category under the Number tab

• Remember the last date shown on the axis

• Click on the axis > Format axis, select Custom for the Category under the Number tab, and enter [=X]“Y”;Z   (in this case [=40263]"3/31/10";m/d/yy)
That means if the value of the axis = X, show Y, and the other value follow the formula Z

And it is done!

Same technique can be applied to the y-axis too.

- End of Tutorial