View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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