Yeah, just use the joins to get data if you aren't charting it. UNION SELECTS would be needed to get the separate rows for each data set that charting would require.
You could just create a static graph or a basic recordset driven graph using the wizard, then you would open the data file to add your recordsets and minipulate the xml from there.