I figured it out thanks to your help. In my case the data are stored in a
worksheet named data, in a file called 'Sales Metrics.xls'. I Have named
ranges like Mprice for average selling price.

In the Source Data dialog or the SERIES definition, you can enter
='Sales Metrics.xls'!Mprice

To refer to the named range MPrice.

I also found a web site with an example spreadsheet:

http://www.spreadsheetgear.com/suppo...finedname.aspx

Thanks for all your help!


"Franz Verga" wrote:

Nel post
*lsilverman* ha scritto:

Tried using a named range, but no luck. I downloaded the example
sheet from Pearson's web site, and tried to graph the dynamic ranges
in his spreadsheet, but also didn't succeed. Perhaps you can't use
named ranges as source data for a chart in Excel?

Lee

I think I remember you can use named ranges in charta, but you have also to
use the nameof workbook, e.g. if you have a named range "myrange" (without
quotes) in a workbook named "myWB.xls", so in the SERIES function you have
to input as [myWB.xls]myrange or something like this... Try also with the
sheet name, because I'm not sure of how it was...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy