Dynamic chart - series label problem
 

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.
--
pignick

Dynamic chart - series label problem
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"pignick" wrote in message
...
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.
--
pignick

Dynamic chart - series label problem
 

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.
--
pignick


"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"pignick" wrote in message
...
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.
--
pignick