How to chart data based on various dates not consecutive

[mathur999]

Hello all. I am trying to chart lab values for patients that had the tests done on various dates that are not linear. The graphs show the dates on the x axis but one after the other and not spread out as they should appropriate ti the time between dates. ie:

y x

---------------------

2.5 Jan 5, 1996

3.1 June 11, 1997

5.6 Feb. 13, 2001

6.3 Dec. 5, 2001

9.3 Aug 12, 2006

Any help all?

[comment]

Unfortunately, that is how Filemaker native charting works: the x values are merely labels, and they are assumed to be uniformly spaced.

See also the winning solution here:

http://www.savvydata.com/contest/

[OptimusPrime]

I have the same issue.

There must be a work around out there. I havent got the foggiest idea what it would look like, but we can't be the only ones or the first ones with this issue. Let me know if you find something, I'll do likewise.

OP

[comment]

The workaround is to use another charting engine - through either a plugin or the web viewer.

[OptimusPrime]

Right! Now I just have to figure that out without looking like an idiot...

[comment]

Filemaker native charting is a new feature. Search the forum (or the web) for charting methods before version 11.

[OptimusPrime]

Google docs does it! Solved. Now I just need to set up import from google docs and win!