This content has been marked as final. Show 2 replies
I have a chart with a Running Total. The data stops mid way through the period, but the line on the chart doesn't stop. It shows all the way to the right edge of the chart, as if the sales went totally flat.
I've made a workbook that boils the problem down as simply as I can. It's attached.
If I set the date filter to Jan 1 - Feb 15, then it works fine. The Feb line stops at the 15th.
If I set the date filter to Dec 1 - Feb 15, then it doesn't work. The (orange) Feb line stretches across horizontally all the way to the right edge of the chart.
Thanks in advance.
Btw there are many threads about this issue but I can't find one that solves it for me.