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


There are two way to do this:


