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