How use name refs for Source Data?

[joeu2004]

In Source Data > Series > Y Values, I want to use name
references (e.g. 'Sheet 1'!Foo:Bar or simply Foo:Bar).
Excel 2003 does not seem to permit that. I also tried
using a named range (e.g. 'Sheet 1'!FooBar or simply
FooBar), to no avail.

Is there some way that I can avoid absolute references
in the chart Source Data?

 

[Andy Pope]

Hi,

You can use named ranges to define chart data. This example uses a
workbook and worksheet level names.

=SERIES(,Sheet1!ChtLabels,Book1.xls!ChtData,1)

Here is a collection of dynamic charting examples,

http://peltiertech.com/Excel/Charts/Dynamics.html
http://processtrends.com/pg_dynamic_charts.htm
http://www.xl-logic.com/xl_files/charts/dynamic_chart_3.zip
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt1.zip
http://www.xl-logic.com/xl_files/charts/dynamic_chart_1.zip
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;147803
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Cheers
Andy