Displaying the Last Date On an Excel Chart

I have Excel Chart that displays the price of a stock through time. The problem I have is that the last date is sometime not shown on the x-axis of the Chart. The first date is always shown. Is there an automatic way of forcing Excel into displaying the last date?

Thanks.