Dynamic Chart with Defined names
 

Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils

Dynamic Chart with Defined names
 

When inputting the defined name into your series, use single quotes, not
double:

='My Book.xls'!dates
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nils" wrote:

Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils

Dynamic Chart with Defined names
 

thanks for your response.

My original post is incorrect, I used single quotation marks in my chart:-

='filename.xlsx'!dates

Sorry for the confusion!

Nils

"Luke M" wrote:

When inputting the defined name into your series, use single quotes, not
double:

='My Book.xls'!dates
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nils" wrote:

Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils

Dynamic Chart with Defined names
 

Have you installed any service packs to your Office 2007 installation?
It's up to SP2. This was a problem when 2007 first came out, but I have
not encountered it for a while.

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



Nils wrote:
Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils

Dynamic Chart with Defined names
 

Thanks Jon,

I think this might be the problem, however it's a work PC so it will have to
go through IT dept to be updated and I'm not sure that would happen!

I have used a work around, using the "large" function for the largest range
of dates and then V-lookup to pick up the corresponding data.

"Jon Peltier" wrote:

Have you installed any service packs to your Office 2007 installation?
It's up to SP2. This was a problem when 2007 first came out, but I have
not encountered it for a while.

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



Nils wrote:
Hi,

I have set up defined names for a range of data, for example "dates" :-

=OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22)

and I have set the series of the x-axis of my chart to:-

="filename"!dates

However, when I go back to the file the series name has been changed to the
following:-

=[0]!dates

so that the chart no longer looks at the latest range anymore. I change the
name of the sheets/tabs after the names were defined and the chart was
created, would this create the problem?

Has anyone come accross this problem, any help is appreciated.

Many thanks,

Nils
.