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
|