do you have a demo file or screenshots?
A screenshot is shown below and also attached.
The record set is sorted on the column named PP in ascending order.
The chart appears in descending order.
I need both to be in ascending order.
Thanks for your help.
SprPaceChtEx111213.png 120.9 K
This seems to just be the native way that Filemaker shows chart data.
The only ways around it are to sort your records the opposite direction, or to use different calculations for your chart data.
I've put together a sample file to show you loosely how to do this a few ways.
I hope this helps, and sorry there doesn't seem to be a native way to flip the order of the graph itself.
graphtest.fmp12.zip 9.5 K
I was afraid that might be the case. I hope Filemaker fixes this in the future.
For now I'll use different calcs for the chart data. After I get my arms around that way, I'll switch to the self-join.
Thanks for your help and samples.