Excel 2007 : Horizontal Axis Label - Last Data Point

Is there a way to include the last data point on the horizontal axis of a line chart even if i switch the major unit to a fixed amount?

For example I have a series of data that ranges from January '06 through June '10 on a monthly basis, and I don't want to include all the months on the horizontal axis, but maybe skipping every 3 months. However, the last label on the horizontal axis is Apr-10 and not Jun-10. Not sure if this is possible, but any help wold be appreciated. I've attached an example of what I'm looking at.

thanks