Mangesh -

The easiest way is to open a new window for the active workbook: use New
Window from the Windows menu. Then arrange the windows so one shows the
chart and the other shows the scrolling worksheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

mangesh_yadav < wrote:

I want to keep my chart stationary in a worksheet (It is not an object
in new sheet) while I scroll horizantally or vertically, so that
whatever changes I make, I can see in the graph directly. Any idea on
how to do this through VBA.

I tried something like :-
ActiveSheet.Shapes("Chart 98").Left 50
ActiveSheet.Shapes("Chart 98").Top 30

But it doesn't work

Mangesh


---
Message posted from http://www.ExcelForum.com/