Dynamic chart - series label problem

  • Thread starter Thread starter pignick
  • Start date Start date
P

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.
 
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
 
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.
 
Back
Top