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
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.