Dynamic Chart with Defined names

[Nils]

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

 

[Luke M]

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

='My Book.xls'!dates

 

[Nils]

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

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!*

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

 

[Jon Peltier]

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

 

[Nils]

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.

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/

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

.