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?

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