It would be helpful if you post the formulas you used to define your names.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


dmkirk wrote:

I am trying to set up dynamic charts for multiple data arrays, but the OFFSET
function will not return more than one reference. If height or width is not
1, I get a #VALUE error. Has anyone had success from "Using named ranges to
create dynamic charts in Excel" in the excel help files? I am running 2003
sp1 excel.