Dynamic Chart with OFFSET defined name not working

[Montse]

Hi,

I am using Excel 2003. I have followed instructions from sites such as
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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/DynamicColumnChart1.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

 

[Luke M]

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

='MyWorkbookName.xls'!MyDefinedName

 

[Jon Peltier]

In the downloaded spreadsheet, values and information for data source are

blank

Where are you finding these blank items? You should look on the Series tab
of the Source Data dialog. Or look in the series formula.

- Jon