How to freeze a chart?

[Frank Rizzo]

Hello,

You know how you can freeze the top row? Yeah. I'd like to freeze a
chart that I have on the sheet, so that I can scroll the data, while the
chart is locked in place.

I am using Office 2007.

Thanks.

 

[Dave Peterson]

Maybe you could just place the chart in the frozen row area?

 

[Frank Rizzo]

Maybe you could just place the chart in the frozen row area?

That does not work.

 

[David Biddulph]

Interesting! It does for me with Excel 2003; surprising that it doesn't in
2007.

 

[Dave Peterson]

Why doesn't it work?

Maybe you can use
window|new window
and
window|arrange (tiled, then resize the way you like)

And keep the chart visible in one of the windows.

When you're done with the multiple windows, you can select the one you want to
close and hit ctrl-w.

 

[Jon Peltier]

It probably works, but you need to put the chart above the seam, so it isn't
on any scrolling regions. I suspect when you say "doesn't work" you really
mean "isn't satisfactory".

- Jon