Not the way the OP is setting it, i.e., ='Foo'!$B$1:bottomright

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
You can set the source data range by referring to a named range, but as
soon as you dismiss the dialog, Excel converts it to the absolute
address of the range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Tushar Mehta wrote:

How are you setting the data range? Is it programmatically through
some property/method? Or is it through the GUI? If the former, I
believe XL/VBA is translating the 'bottomright' into the current value.
If the latter, I would love to know how, because I cannot set that
through the Chart Wizard.

Bottom line: I don't believe it is possible to specify a multi-column
range through a named dynamic formula. You can establish *up front* a
range for a single column (see the Dynamic Charts page of my web site)
and specify other ranges relative to this column. The examples on the
Dynamic Charts page show how.