When inputting the data source, include file name, so it looks similar to:

='MyWorkbookName.xls'!MyDefinedName
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Montse" wrote:

Hi,

I am using Excel 2003. I have followed instructions from sites such as
http://pubs.logicalexpressions.com/P...cle.asp?ID=246 with very
clear explanation on how to enter the OFFSET property in Defined Names. I
even got a spreadsheet from
http://peltiertech.com/Excel/Charts/...umnChart1.html

The problem:
When I enter the defined names in the data source of the chat it gives error
message "The formula you typed contains an error".

In the downloaded spreadsheet, values and information for data source are
blank, meaning the same (that is not able to understand a defined name
entered as Value for the range to chart)

Please could anyone help me with this?

Thanks,

Montse