If it helps, using the TODAY() feature I have turned the date for days in the future "". Is there anyway to have the excel only chart cells that have a value in it?