Dynamic Chart with Defined names

  • Thread starter Thread starter Nils
  • Start date Start date
N

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
 
When inputting the defined name into your series, use single quotes, not
double:

='My Book.xls'!dates
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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
 
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 said:
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
Click to expand...
.
Click to expand...
 
Back
Top