6 Replies Latest reply on Jan 20, 2014 9:21 AM by bryanmoser

    FMP12 scatter chart: Misaligned axis ticks/labels when using dates

    Dillik

      Summary

      FMP12 scatter chart: Misaligned axis ticks/labels when using dates

      Product

      FileMaker Pro

      Version

      FMP 12.0v1

      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.

      Expected result

      The ticks should understand dates (whether the tick quantity is auto or manual).

      Actual result

      The ticks don't understand dates in either case.

      axis-ticks.png