FMP12 scatter chart: Misaligned axis ticks/labels when using dates
Operating system version
OS X 10.6.8
Description of the issue
When a date field is used for either axis's data in a scatter chart, the tick marks are awkwardly spaced and sometimes include duplicate date labels at a small enough scale. Also, using "show major ticks" or "show minor ticks" causes all of the tick marks to bunch up at one end of the axis.
Steps to reproduce the problem
Create a sample table called Chart, and give it fields X (a date field) and Y (a number field). In browse mode, create three records with respective X and Y values of 1/1/2012, 1; 1/2/2012, 2; 1/3/2012, 3.
Create a scatter chart using this found set (either in layout mode or from the column headers in table view). X-axis data should use the field Chart::X with data type "Date," and Y-axis data should use the field Chart::Y with data type "Number." Enable "Show major ticks" for the X-axis and look at the resulting X-axis ticks. In the chart preview (and when viewed in browse mode), dates are duplicated and sometimes even out of place relative to the horizontal positioning of the data points in the chart.
Now try to set the X-axis major tick quantity to a non-auto value; all ticks will be bunched up on the left.
This problem occurs whenever the referenced field contains date data, whether or not you've selected "Date" as the data type in the axis options (changing it to "Number" makes it display dates as number codes but still uses the confused spacing). It applies to both X- and Y-axis dates.
The ticks should understand dates (whether the tick quantity is auto or manual).
The ticks don't understand dates in either case.