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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to insert and move columns 3
Two Sources - One Report 3
Copying Charts While Changing Source Data 8
Charting Missing data accross three related tables by region and % 1
Calculating a Grand Total Based on Computed Field 4
sum of getpivotdata() 0
Pivot Table % Variances 0
Include info from data source in data table but not in chart 1

Back
Top