Keep chart stationary on worksheet when scrolling

Eruantano

Board Regular
Joined
Apr 12, 2008
Messages
59
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.
 
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. :-)
 
Upvote 0

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Forum statistics

Threads
1,224,538
Messages
6,179,412
Members
452,912
Latest member
alicemil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top