Dynamic Chart with OFFSET defined name not working

  • Thread starter Thread starter Montse
  • Start date Start date
M

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
 
When inputting the data source, include file name, so it looks similar to:

='MyWorkbookName.xls'!MyDefinedName
 
In the downloaded spreadsheet, values and information for data source are
blank
Click to expand...

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
 
Back
Top