AnsweredAssumed Answered

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

Question asked by Dillik on Apr 10, 2012
Latest reply on Jan 20, 2014 by bryanmoser

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

Outcomes