View Single Post
  #2   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,

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