Hello,

I have created a Line Chart to compare Planned Progress to Actual Progress per day from a simple data series (Date, Planned %, Actual %)
I am using a function that gets the Actual Progress from another chart per day. My problem is that the Actual chart line returns to 0% for dates later than actual day since the cell has no data (only formula).
How can I tell the chart to show nothing?? just like it does when no formula is typed in??


Chart.PNG