Min ( fieldname ) and Max (fieldName )
probably aren't producing the results that you think.
both require a list of fields or a repeating field before they return anything but the value of a single field in the current record.
Max ( 4 ) is 4 after all, it's just not referring to the values ( 5, 3, 6 100 ) found in other records in your table.
Max should be used like this:
Max ( RelatedTable::Field ) , Max ( Field 1 ; Field 2 ; Field 3 ) or Max ( repeatingField )
None of these options return the maximum value for your current set of records in your found set.
Min follows the same rules. It may be returning an acceptable value purely by accident.
If your chart is charting values from a found set of records, try defining a pair of summary fields that compute the maximum and minimum values and then refer to these summary fields instead of using the Max and Min aggregate functions.
You might also be able to use ExecuteSQL() to get the max and min values. (FileMaker 12 or newer only.)
I guess I'm confused. I use Max and Min in other layouts and it always produces the correct minimun and maximun values. Some of these databases contain 400,000 records and they always find the exact min and max values of the found set. I did go back and create a summary field for Min and one for Max, then used that field name for the Axis options for Set Min and Set Max and it works like it's supposed to. Thanks for the help.