Name to define a chart range

[mge]

I am trying to use names to define the data and label ranges for my charts
but get an error message that my formula is incorrect. I have entered the
formula below and it works when not used in the chart tool. When I enter the
name in the chart tool I get an error message that my formula is incorrect.

I am using Excel 2007

CARLOW=OFFSET(SmallA!$B$119,0,0,'Calc Screen'!$Y$2,1)

 

[Jon Peltier]

You do know, don't you, that you put "CARLOW" into the "Name" field of the
dialog, and "=OFFSET(SmallA!$B$119,0,0,'Calc Screen'!$Y$2,1)" into the
RefersTo or Formula field (whatever it's called nowadays).

The formula itself looks okay.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[mge]

Yes, That is how I created the name but when I put the name in the chart tool
in the series value as =[0]'CARLOW I get the error message. Also, when I
enter the formula itself I get the same error message.

 

[Jon Peltier]

What's the [0] mean?

Prefix the name by the worksheet name in the source data dialog:

='Data Sheet'!CARLOW

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

Yes, That is how I created the name but when I put the name in the chart
tool
in the series value as =[0]'CARLOW I get the error message. Also, when I
enter the formula itself I get the same error message.
--
mgelde

You do know, don't you, that you put "CARLOW" into the "Name" field of
the
dialog, and "=OFFSET(SmallA!$B$119,0,0,'Calc Screen'!$Y$2,1)" into the
RefersTo or Formula field (whatever it's called nowadays).

The formula itself looks okay.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______