Can a named range be used in a chart for one of the series? I have tried
this, and it doesn't seem to work.
For instance, i have a name _Date_rng defined (using Insert...Name...Define)
as "data!$A$2:$A$60". In a chart (XY scatterplot), for one series, i define
the X values as _Date_rng. Excel formats this as ={"_Date_rng"}. However,
the chart is now blank, it draws with the axes, but no data is plotted.
But, when i put the range directly in the chart "Source Data...Series" tab
as "data!$A$2:$A$60", it plots the data correctly.

So, is it possible to use a Defined Name (defined as a range) for the series
of a chart? If not, is there any recommended workaround, as i have many
series i'd like to use the same defined name for, so that i can change it in
one place and all the series will be adjusted.

Thank you . Tom