How to freeze a chart?

F

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.
 
D

David Biddulph

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

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.
 
J

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
 
Top