After a lot of thinkering I realized that the data in charts are affected by the way the records are sorted, so I made a script to auto-sort data "onLayoutEnter", problem is, on the same layout I have another graph that, in order to be visualized correctly should have been sorted by another field. Now, my question is, is in any way possible to have two different sort-order for each of the two graphs? Or is it the only way to achieve that to make two separate layouts with two separate sort orders? I am asking since the ideal solution for me would be to have all charts on the same layout instead of having to put them all in different layouts.

If I understand your question correctly, the answer is "yes". I have a layout that has buttons that sort by different fields and the same field in different direction. I sort depending on my whim at the time.

This seems to be a duplicate thread:

http://fmforums.com/forum/topic/85680-find-script-to-get-the-most-profitable-sales/