Keep chart stationary on worksheet when scrolling

[Eruantano]

I tried searching for this both here and through google without any luck. I'm not sure if I'm using the correct search terms, but here is the gist of the problem (if the title isn't clear enough!). =)

I'm hoping to be able to keep a chart stationary while scrolling through a worksheet entering data. A few points:

1) 'Freeze pane' wouldn't work for me since the chart is too large and I'd prefer to have the data sheet unfrozen for easy perusal.
2) I saw mention of opening a separate window with the chart in it, while having the workbook window aligned next to it. I don't know if that can work, but I'd also prefer to just have the chart on the worksheet and stationary. Either way, I didn't see any sample code listed for this option and would appreciate help with that if this is the only viable option.

Excel gurus... please help!

Thanks a lot.

 

[VikingOy]

What might be happening is:
• You are scrolling by using the horizontal or vertical scroll bar which means you are not selecting a cell, or
• You have the code in a module other than the module of worksheet that holds the chart, or
• Your chart object is not index chart #1 (I doubt this is the reason).

You are right - thanks for answering. It was not clear to me that the code depends on actively selecting a cell. I was hoping it would work "real-time" - meaning; It would enable the graph to stay put when I use the scroll wheel on my mouse.

If that's not possible, I guess the current implementation will have to do for now.

 

[matthewn5]

That's brilliant, thanks so much!