Auto-updating charts
 

Hi all,

I am trying to build a chart that only has the last 26 weeks worth of data and updates every week.

So, I would like week 1-26 then 2-27, then 3-28 etc etc.

Any help would be greatly appreciated. I only need to see 26 data points

Many thanks in advance

Jooniper

Auto-updating charts
 

Hi,

Am Mon, 12 Sep 2016 16:13:07 +0100 schrieb Jooniper:

I am trying to build a chart that only has the last 26 weeks worth of
data and updates every week.

So, I would like week 1-26 then 2-27, then 3-28 etc etc.

your week numbers in column A, the values in column B.
Create names for both columns:

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

Now you can use these names as source for the chart.
Legend entries: =YourWorkbookName!y_Values
Category: =YourWorkbookname!x_Values
The workbook name has to include the file extention.

Regards
Claus B.
--
Windows10
Office 2016

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

Thank you very much