 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / September 2007How to freeze a chart?
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. Maybe you could just place the chart in the frozen row area? > Hello, > [quoted text clipped - 5 lines] > > Thanks.  SignatureDave Peterson > Maybe you could just place the chart in the frozen row area? That does not work. >> Hello, >> [quoted text clipped - 5 lines] >> >> Thanks. Interesting! It does for me with Excel 2003; surprising that it doesn't in 2007. SignatureDavid Biddulph >> Maybe you could just place the chart in the frozen row area? > > That does not work. >>> Hello, >>> [quoted text clipped - 5 lines] >>> >>> Thanks. 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. > > Maybe you could just place the chart in the frozen row area? > [quoted text clipped - 9 lines] > >> > >> Thanks. SignatureDave Peterson 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >> Maybe you could just place the chart in the frozen row area? > [quoted text clipped - 9 lines] >>> >>> Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.