We'd need to know:
What version of FIleMaker, 11 or 12?
How your tables/relationships that contain this data are set up.
All the options you have currently specified for your chart--not just what you've selected for the X-axis.
Filemaker pro 12. I have attached the screen shot image.
You didn't indicate how your tables/relationships are set up. Your screen shot identifies two tables. How are they related to each other?
Is your layout for the chart based on employee or BV_CustomerPayment?
its based on employeePreferencesPreferences
Presumably, it's based on BV_Employee. (The details are critical.)
And what is the relationship between BV_Employee and BV_CustomerPayment ?
Is BV_CustomerPayment::Amount a number, calculation or summary field?
I would guess that you have this relationship:
BV_Employee::__pkEmployeeID = BV_CustomerPayment::_fkEmployeeID
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
I would also guess that Amount is either a number or a calculation with a Number result. If so, then you can define a calculation for your Y-Axis data series as: Sum ( BV_CustomerPayment ).
However, the resulting chart will chart the total payments linked to each employee over all the records in BV_CustomerPayment. To see this same chart for selected sets of records in BV_CustomerPayment, I recommend that you use a layout based on BV_CustomerPayment and a Summary field that computes the total of Amount as the Y-Axis. You will also then need to sort your records by EmployeeID to group them properly and specify the Data source options for summary values from "grouped data when sorted".
With that approach, you can get charts of payment data over any date range you want by performing a find for those records and then sorting them as needed to get the proper groups of records for each employee.