Creating a line graph from 2 pivot tables?

G

Guest

Hello,

I have two pivot tables, one contains information RECEIVED in a week for a
country and the other contains information ACTIVATED in a week for a country.


The countries and time range are the same for both.

Within the line graph I would like to show, how many things were RECEIVED
and ACTIVATED for that country in that week?
I am able to show either the country or the time range but not both.

How can I show both? Is this possible?
 
G

Guest

Try using the multiple consolidation ranges in the pivot table options. You
should be able to bring both tables into one and then chart it from there

Best of Luck
Dan
 
G

Guest

Hello,
Thank you for replying. I'll try your suggestion.

Here's is my email address, (e-mail address removed).
 

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

How can I work out percentages of a particular column? 1
Disabled "Switch Row/Column" when creating chart from a pivot tabl 1
Graph Line Width ? 1
Pivot Table with Pages 2
Possible to have a "dynamic" pivot chart title? 1
How do I compare output data from 2 pivot tables in a graph forma. 2
Combining a 2-D column graph and a 2-D line graph on the same char 3
Line graphs 3

Top