Chart Data Source Restrictions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to create a chart using two queries as data sources?
The first query has regional sales variance to budget.
The second query has the national average variance to budget.
The objective is to show each region's perfomance relative to the national
average.
Formula: Variance.Region - Variance.National

Thanks very much in advance.
 
These queries should have a common field/value that allows you to combine
them into a single query.
 
Back
Top