up vote 0 down vote favorite
1
share [g+] share [fb]

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?

link|improve this question
78% accept rate
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
feedback

1 Answer

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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