You have two options:
1) Omit those records from your found set. This is the simplest approach as you just need to perform a find that omits records with this value in TestOmit, but in some types of charting, this doesn't work as you may need a 'space' for the value in your x-axis even though you are not charting the value.
2) This get's a bit hairy, but you can set up a calculation that uses the y values preceding and following this value to interpolate a "place holder" value to use as a Y value. This charts the average of the preceding and trailing y values to keep the line in place as a straight line drawn between the values you averaged. Where this get's sticky is that you might have 2 or more omitted values in a row. To handle that, I think you'd need a script that looped through your records and computed the needed interpolated values for the omitted y values. (Remember your point slope formula for computing the equation of a line between two pionts?)
Thanks for the response. Is there a way to have a looping script that always "omits" checked records the minute someone fires up the database. Therefore all "omits" are out right off the get go and not available to any other layouts, charts, etc.. That way I am not writing a script or calculation for every new instance of a portal, chart, etc., to omit the checked records. I would not like to have them show at all in any part of the database unless I make a layout to specifically show omitted records...
Or a script attached to each omit checkbox on each layout that would omit the record, not reseting after "Show All" used in other scritps...
No need for a looping script.
Use a script like this:
Enter Find Mode
Set Field [Products::TestOmit ; "Omit" ]
Constrain Found Set
You can set this script to be performed by layout script triggers such as OnLayoutEnter for when the user accesses a layout and OnModeChange to automatically modify the results of a user's manual find.
You can also set up scripted finds for the user to use that automatically includes criteria to omit the Omitted data.
Thanks Phil, that will take care of the problem.