Dynamic Chart with Defined names


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
 
Ad

Advertisements

L

Luke M

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

='My Book.xls'!dates
 
N

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

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
 
J

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
 
Ad

Advertisements

N

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.

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
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top