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)

--
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...00906ACNJ.html
_______


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

--
mgelde

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


"Jon Peltier" wrote:

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...00906ACNJ.html
_______


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

--
mgelde

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...00906ACNJ.html
_______



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


"Jon Peltier" wrote:

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...00906ACNJ.html
_______


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

--
mgelde