I have created a Excel Line graph comparing cummalitive Planned vs Forecast vs actual dates for testing of equipment. I have managed to create the graph however I would like to use a formula that will stop the "actual" cummalitive line after todays date (instead of just carrying on as it is currently doing see image) Can anyone help?
My current graph is:
And my data is:
I have attempted =IF(data actual>TODAY(), NA(), COUNTIF(Data actual, date in top row column))