How do I freeze a chart from scrolling

[dannie]

I want to freeze a chart so as I scroll through data it will not go up or
down, I dont want it to be frozen in a horizontal position. Is there a way
this can be done?

 

[Andy Pope]

Hi,

You would need to freeze a number of rows at the top of the sheet and
place the chart there.

Or use New Window to create a copy of the worksheet. One would display
the chart then other would be used to scroll through the data.

Cheers
Andy