Exclude data points in an excel graph without deleting them

I have an excel workbook that automatically runs once a week, pulls in raw data using a plug-in, and creates graphs/tables automatically based off of that raw data. I want the graphs to not plot certain points (more specifically, points whose values are greater than 999999 or less than or equal to 0), but I do not want to simply remove those points, because they are reported in a different table elsewhere on the workbook. I also want to avoid what is essentially copying/pasting a whole new table in without those handful of bad values. Does anybody know of an easy way to do this? If necessary, I can add VBA code in, as long as the workbook as a whole stays lightweight.