Dynamic chart - series label problem

[pignick]

I have successfully created some dynamic charts using articles referred to
here, but am struggling with one problem. The sheet is set up so that I
enter an EndDate and the StartDate is calculated from this (21 weeks back) so
I am plotting 21 pieces of data (weekly entries of various parameters). If I
choose an EndDate that is several weeks back from the latest date entered the
data plots are adjusted correctly but the x-values labels always show the
last 21 weeks of dates and therefore do not change with the data. I must be
missing something here - any suggestions would be most welcome.

 

[Andy Pope]

Hi,

Sounds like you need to apply the same changes to your named range for
Labels as you have for the data one.

Cheers
Andy

 

[pignick]

Thanks Andy - that has certainly pointed me in the right direction. Although
I had named ranges set up for the labels some of them were worksheet specific
and some were available in the whole workbook and presumably one takes
precedence over the other. I now need to get my head around that issue - if
I can't find the answer to that in the help files or other posts, or simply
by trial and error I may be back again. Cheers.