Is it possible to create a chart with data from 2 different tables?
Answer: Yes. You must be using a data source that allows custom SQL, and enable "Allow Custom SQL" in the data source settings. When designing your chart, use "Custom SQL" when selecting your data source and create a SQL statement to pull columns from your desired tables.
The process to link the table is a join
Example of a inner join: select * from table1 A inner join table2 b on a.id = b.id