• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding shaded 'window' to a line chart


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!