Hi,

I'll try to get back to you later, but for now try replacing the sheet
references with workbook names (without sheets names)

--
Thanks,
Shane Devenshire


"Marc Pelletier" wrote:

Hello,

I have a spreadsheet with about 10 columns of data. The number of rows can
vary but its ussually less than 20. I've got a set of 'index' fields that
define which data is in which column and what range of rows I want to act
on.

Then I've defined some named ranges that vary based on the contents of the
index fields. For example:

Stats!TotalC==OFFSET(INDIRECT(stats!$O$3&FIXED(sta ts!$P$2,0,0)),0,0,stats!
$Q$2-stats!$P$2+1,1)

where O3 contains the column name, P2 is the first row, and P3 is the last
row I want to consider.

I've also defined them as follows:
Stats!Th=INDIRECT(stats!$O$6&FIXED(stats!$P$2,0,-1)&":"&stats!$O$6&FIXED
(stats!$Q$2,0,-1))

I've tested and used these named ranges in functions and they work
properly, but I can't use them in a chart for some reason. If I define them
as above, with the sheetname then I simply end up with no data. If I don't
include the sheetname then I get a message that there is a problem with the
function ('one or more invalid references' );

I'm sure this can be done, but I've been banging my head on it for a while
already. Can anyone point me in the right direction?

I'm using Excel 2003.

Thanks

Marc Pelletier
Goldak Airborne Surveys