Excel VBA - Keeping a chart stationary in a worksheet while scrolling

M

mangesh_yadav

I want to keep my chart stationary in a worksheet (It is not an objec
in new sheet) while I scroll horizantally or vertically, so tha
whatever changes I make, I can see in the graph directly. Any idea o
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

Manges
 
F

Frank Kabel

Hi
you may consider using 'Windows - Freeze Panes' and place the chart in
the 'freezed' area
 
M

mangesh_yadav

Hi Frank,

Thanks for the response, but I considered that possibility and th
results are
1. with that option I would have to place the chart in the topmost ro
and then freeze so that I get more area to work with.
2. This would not work when I move the chart to a new location.
3. It doesn't work. When you scroll down, the chart disappears.

- Manges
 
J

Jon Peltier

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/
_______
 
M

mangesh_yadav

Hi Jon,

Thanks for the response, but the problem is I cannot ask the client t
do so. What I want is that once the client moves the chart to
specific location, it remains there - relative to the screen - until h
moves it again. So even if he scrolls the sheet, the chart i
stationary with respect to the screen.

Manges
 
J

Jon Peltier

I didn't mean ask the client to do it. I meant write a procedure to do it.

- Jon
 
M

mangesh_yadav

Well, Jon, I am sorry for the mis-understanding, but it still does no
solve my problem. The user has to keep 2 windows open in that case.

- Manges
 
Top