How can I create a chart that compares values from multiple tables?

[sbstrand]

Hi all,

I would like to create a chart that compares my budgeted spending to my actual transactions. Is there any way I can do this?

This is the chart I am trying to recreate:

Here are the table structures of the tables that contain the data I would like to compare:

Thank you!!

[TeeSee1]

Since a graph can handle data from one table you need to bring data into one table. I believe in your case you should create a VC in the budget detail table that SUMs the values of the referenced budget transactions occurring in the relevant period.