How do I freeze a chart from scrolling
 

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?

How do I freeze a chart from scrolling
 

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

dannie wrote:
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, Microsoft MVP - Excel
http://www.andypope.info