By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,231 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

Multi charts

P: 38
Hi All,
How can I plot 2 line charts with data coming from 2 different tables in one PivotChart view in Access.
Sep 18 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Best to use a UNION query like:
Expand|Select|Wrap|Line Numbers
  1. select "A" as Origin, field1, field2 from tblA
  2. UNION ALL
  3. select "B" as Origin, field1, field2 from tblB
  4.  
Now all data is combined and the Origin field could be used to keep them separated in the pivot table.

Nic;o)
Oct 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.