I'm trying to add a window (if that's even the right term) to a line chart. I've done a mockup attached - it's just a line chart with a yellow rectangle drawn over it.
Is there a way to actually add this rectangle as part of 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!
Is there a way to actually add this rectangle as part of 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!