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
|