I have a sheet that automatically pulls in order numbers every month, and a chart to show the trendline. I have formatted the future months because I want the chart to be automatically updated. But the value of the order numbers for future months in currently 0 and that messes with my chart. I want those to be hidden from my chart, so that the chart only runs to the last month.

Example sheet: