Thank you, thank you - it works perfectly. No adjustments needed

"Del Cotter" wrote:

On Wed, 22 Aug 2007, in microsoft.public.excel.charting,
Corrine said:
Thank you for the solution. I'm sorry it took me so long to test it. It
works great. Of course, I want more :-)

I now want it to only count the last thirteen columns of data in the table.

Jon described an expression like

=OFFSET(Sheet1!$A$1, 0, 0, 1, COUNT($1:$1) )

which read all columns in the row. I think the last thirteen columns
will be an expression something like

=OFFSET(Sheet1!$A$1, 0, COUNT($1:$1)-13, 1, 13 )

i.e. it now starts thirteen columns from the right, and extends for
thirteen columns.

I may have made a fencepost error there, but I'm sure you'll be able to
fix it when you test the expression.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.