Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .