





xmCHART supports a wide range of other diagrams and its own scripting language means that there are practically no limits to the possibilities. Nevertheless, the scripting language has been kept very simple - three lines are enough to create a diagram with xmCHART:
OpenDrawing(400;300) // width & height ChartData(23 45 -2.76 12.9 5; 24 13 8.5 -3) BarChart(shadow+horizontal)
A total of over 150 functions are available to vary diagrams in all possible ways. The source text for the diagram can be easily created in a formula or text field.
Obtain values from relational tables
As can be seen in the example above, the values for a diagram are each transferred in the source text separated by a space:
ChartData(23 45 -2.76 12.9 5; 24 13 8.5 -3)
If the data from a relationally linked Table are passed, this can be done with the function List () possible. The following is an example of how data can be obtained from a relationally linked table:
Exchange(List(Statistics::Total_Net); "¶"; " ")
The List () command first retrieves all matching values from the relationally linked table, each separated by a line break. However, as xmCHART expects the data to be separated by a space, the command also converts the line breaks into spaces.
Licenses and prices
xmCHART offers single-user, multi-user and developer licenses. A single user license costs 129 US dollars, for five users the multi-user license costs 360 euros, and for 10 users it costs 600 euros. Licenses for developers also depend on the number of licenses (users) used and start at 460 US dollars. A developer license can be used in any number of companies with the maximum number of users included.
Conclusion: Indispensable for statistics
xmCHART is probably the best and most comprehensive chart plugin available for FileMaker. Every FileMaker developer whose applications contain graphical evaluations of figures should definitely consider this plugin. Another positive aspect is that the diagrams generated are vector graphics which can be scaled without loss in FileMaker as well as in any other application.

Markus Schall has been developing individual databases, interfaces and business applications based on Claris FileMaker since 1994. He is a Claris partner, FMM Award winner 2011 and developer of the ERP software gFM-Business. He is also a book author and founder of the M. Schall Publishers.
