Dynamic chart grouping days to week

[Matt9114]

Hello guys , i have a problem with my dynamic chart. I need create lot of dynamic charts showing only last 7 days . One of charts its only with two data . This is working perfect for me , i use OFFSET function and made custom data for chart as you can see in image . But , in my next chart i need see same data but with week no , again as you can see in image 2 .This chart is looking how i want but is not dynamic , i need dynamic weeks and days , days sorted with weeks . My problem is making this chart dynamic showing only last 7 days . Please help , many thanks Worksheet included .

Capture1.PNG
Capture2.PNG

[52779]

Hi,

If I understand your question correctly see attached document.
Defined Names were used to obtain lists.
Lists refer to graphics