Dynamic Named Range As Chart Series

Hi all,

Using Excel 2010

I am trying to enter a Dynamic Named Range (DNR) as a chart series.
My DNR:

nTotalSample = Results!$D$3:INDEX(Results!$D:$D,COUNTA(Results!$D:$D)+1)

Dancing ants appear around the expected range.

I then clicked on a chart..select data..Legend Entries (Series)..Edit..Series Values

I tried entering the name and I tried =name
I receive an error every time, "The formula you types contains an error...."

What can I do to make the series a dynamic range?

thanks
w

Thanks igoodable,

The DNR seems to work, I prefer INDEX() as opposed to OFFSET()
I have a DNR for each column in the table and a corresponding chart for each

I created a new named range based on your formulas above
I then followed the steps I outline above to use the DNR as the source for series and I receive the same error message

thx
w

I tried entering the name and I tried =name

Instead of your DNR 'nTotalSample' also include the Sheet name

hence input
=Sheet1!nTotalSample

Perfect!

Thanks Ace,
w