How to Change values dynamically in chart.

[#1]

Hi All,

I have 2 week's as below ,I need for that FW,what is the data from the latest selected PW and the corresponding PW's FW's data.

Please find the attached Excel for sample data and more information.

PW	FW
1C	C+1
1C	C+2
1C	C+3
2C	C+1
2C	C+2
2C	C+3
3C	C+1
3C	C+2
3C	C+3

Thanks!

[Gysbert_Wassenaar]

See attached qvw.