Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have 2 columns of data and a chart on the right side.

I'd like to freeze the location of the chart so that I can scroll up and down to view the data while viewing the chart at the same time.

How do I do this in Excel 2007?

share|improve this question
    
Dear Zian Choy. If this answer worked for you, please accept it. Thank you. Kije. –  Kije Nov 30 '09 at 1:03
    
I've been a little busy w/ Thanksgiving. I'll accept it once I have a moment to check it. :) –  Zian Choy Nov 30 '09 at 4:05
    
Thanks. Hope it was helpful. Kije. –  Kije Dec 8 '09 at 3:33

1 Answer 1

up vote 0 down vote accepted

There are two way to do this:

  • One is to open a second window to the same worksheet, so you see the data in one and the chart in the other - in Excel 2003 it is found in Window > New Window. It will be in a similar place in Excel 2007.

enter image description here

  • The second method is to split the window into two panes, either top and bottom or left and right. These can be scrolled independently.

enter image description here

enter image description here

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.