Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a line graph from 2 pivot tables?
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? |
#2
|
|||
|
|||
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 "gmodi" wrote: 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? |
#3
|
|||
|
|||
Post your email address and I'll send you a sample WS
"cs02000 - Dan" wrote: 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 "gmodi" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
creating a directed graph from XY scatter | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |