Dynamic chart - series label problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pignick - 27 May 2008 07:33 GMT

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.

Signature

pignick

Reply to this Message

Andy Pope - 27 May 2008 09:33 GMT

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

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>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
[quoted text clipped - 8 lines]
> be
> missing something here - any suggestions would be most welcome.

Reply to this Message

pignick - 27 May 2008 19:54 GMT

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.

Signature

pignick

> Hi,
>
[quoted text clipped - 16 lines]
> > be
> > missing something here - any suggestions would be most welcome.

Reply to this Message