I'm trying to add a window (if that's the right term) to a line chart. I've done a mockup attached - it's currently a line chart with a static yellow rectangle drawn over it.
Is there a way to actually add something like this rectangular window to the chart and make it dynamic based on cell values? I want it to stretch from Week 36 to 39. I had thought about adding a very transparent bar with an x value of 800000 but that won't stretch over the three weeks.
Your help is much appreciated!
![test_chart.JPG test_chart.JPG](https://chandoo.org/forum/data/attachments/74/74191-7bef1eda57c09c7e1215ee8430e321d9.jpg)
Is there a way to actually add something like this rectangular window to the chart and make it dynamic based on cell values? I want it to stretch from Week 36 to 39. I had thought about adding a very transparent bar with an x value of 800000 but that won't stretch over the three weeks.
Your help is much appreciated!
![test_chart.JPG test_chart.JPG](https://chandoo.org/forum/data/attachments/74/74191-7bef1eda57c09c7e1215ee8430e321d9.jpg)