I want to chart two series of data in comparison.
Each is based on a different relationship, but in the charting you can only select one related table.
Am I missing something or us this just what it is?
this might be a good use case for the venerable Virtual List technique.
its a very useful tool to master and well worth the time and effort
Using the Virtual List Technique - Part 1 - Soliant Consulting
The table that you select in that dialog forms the "context" for any data you choose to chart. Data from other tables could be included in that chart, but much depends on the type of chart and how your data is organized as to whether that produces something that you can work with.
In addition to virtual list, charting delimited data produced from an ExecuteSQL query can also be a way to go for such charting.
And FileMaker Chart objects are not your only option for charting data either.
Retrieving data ...