View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Auto-updating charts

Hi again,

Am Mon, 12 Sep 2016 19:03:14 +0200 schrieb Claus Busch:

1) Name = x_Values
RefersTo: =OFFSET(Tabelle1!$A$1,MATCH(MAX(Tabelle1!$A:$A),Ta belle1!$A:$A,0)-1,,-26)


if it is possible that you have sometimes less than 26 weeks change the
forumula to:
=OFFSET(Tabelle1!$A$1,MATCH(MAX(Tabelle1!$A:$A),Ta belle1!$A:$A,0)-1,,-MIN(26,COUNTA(Tabelle1!$A:$A)-1))


Regards
Claus B.
--
Windows10
Office 2016