Step 3: Chart Layout (Chart Report)
If you use a date or date/time field as a category field and the Add missing date values setting for that field is turned on (the default), missing values are automatically added to the chart, and the range of those values respects any date filter you use. For example, in the following chart, the only dates that had orders were 07/04, 07/05, and 07/08, but the filter condition was Order Date is between 07/01/1996 and 07/08/1996, so all days between those dates appear whether they had any orders or not:
To specify where a field goes, drag its name from the list on the left to the appropriate place at the right. For example, to use the Amount field as the values field, click it in the list, hold down the mouse button, and move the mouse until it's over the box below the word "Values," then let go of the mouse.
To remove a field from a place on the report, drag it from the appropriate box back to the list at the left or select it and press the Delete key.
To change how a field appears in the report, select it and click the Properties button. This displays the Properties dialog. You can also display this dialog by double-clicking the field or selecting the field and pressing Enter.
Step 3 shows a sample of what the chart looks like based on the fields you've selected and their properties. However, it does not show actual data from your database until you click the Preview button.