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
Bookmarks