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