Offset Problem?

[hallingh]

Hi all. I'm adding a scroll bar to a chart, and I'm doing this by using a named range for the values of the graph, and defining the named range using the offset function with the amount of rows offset determined by a cell linked to the scroll bar on my graph. Here is what my named range is defined as:

=OFFSET(Data_Import!AF125, Data_Import!M116, 0, Data_Import!P116, 1)

AF125 is the correct cell for the basis of the offset, m116 is the cell that is linked to the scroll bar, and is currently equal to 1. P116 is currently equal to 10, and I have that instead of a constant number so the user can adjust how many values he wants to display in the chart.

The chart will not accept this function as its data values, and when I simply type this into a cell it gives me a Value error. Does anyone have any idea why this won't work and/or what I can do to fix it? I've been looking at this for a while, and cant seem to get it to work!

Any help at all that you can give me will be greatly appreciated. Thanks!

Hank

 

[hallingh]

Ah, I figured out why I get the Value error, but it doesn't help me solve my problem at all. Putting the formula into a cell gives me the error because it is referencing a range which can't be displayed in the single cell. This still doesn't explain why this won't work for my graph, though?




Thanks again for the looks!