Multi charts

[fd1]

Hi All,
How can I plot 2 line charts with data coming from 2 different tables in one PivotChart view in Access.

[nico5038]

Best to use a UNION query like:

select "A" as Origin, field1, field2 from tblA
UNION ALL
select "B" as Origin, field1, field2 from tblB

Now all data is combined and the Origin field could be used to keep them separated in the pivot table.

Nic;o)