Chart Zooming
 

I'm writing an application that will allow a user to zoom in on a chart
page. However, the zoom function defaults to upper left edge of chart.
How can I cause the initial view to be based on the upper right edge of
chart. During zoom-in the scroll bars appear but I don't know how to
move them in VBA assuming that is the way I should tackle this problem