Dynamic Chart with OFFSET defined name not working
 

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

Dynamic Chart with OFFSET defined name not working
 

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

Dynamic Chart with OFFSET defined name not working
 

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Montse" wrote in message
...
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