I got some basic knowledge about charts but the thing I'm trying to accomplish goes beyond my knowledge. I tried to find something similar on the net but couldn't find one. I hope some of you guys can help me.
I got several rows of data on which row 4 corresponds with row 9. 5 with 10 and 6 with 11. In other words when a period is selected both corresponding rows should appear in the plot.
This brings us to the second problem. I've no idea how to make a chart where I can select a period [week] and can choose which data I want to be displayed [row 4 and 9 or 5 and 10 etc.]
In the attachment you'll find the data. I really hope some of you can help me with this.
Bookmarks