If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
show results of two pivot charts
I have two sets of data ranging from 2000 to 2006 split into monthly totals
One set relates to Units produced per month; the other to units sold per month I want to show both sets of data in a Pivot table together on one linear pivot chart. Anybody know how I can manage this ? thanks |
#2
|
|||
|
|||
show results of two pivot charts
In the first step of the PivotTable wizard, use the 'Multiple consolidation
ranges' option. In the next step you will be asked about page fields. Select the 'I will create the page fields' option. In the next step, add as many ranges as you want -- well, in your case that will be two. Select the first table (months and unit sales columns ) and click Add. Then, select the 2nd table (months and sales$ columns). and click add. Make sure you set the 'How many page fields do you want?' to zero. The rest is like any other PT. -- Regards, Tushar Mehta www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "johnjmcdermott" wrote: I have two sets of data ranging from 2000 to 2006 split into monthly totals One set relates to Units produced per month; the other to units sold per month I want to show both sets of data in a Pivot table together on one linear pivot chart. Anybody know how I can manage this ? thanks |
#3
|
|||
|
|||
show results of two pivot charts
Thank you for your reply, Tushar. Unfortunately the result of your answer is to consolidate both ranges of data and show the accumulated result as a single linear chart. My requirement is to show both data ranges as separate linear graphs on the one page so that comparisons can be shown , graphically, between the two ranges. Thank you for your hepl and perhaps I may not have expressed my problem fully in the first instance. John Mc Dermott "johnjmcdermott" wrote: I have two sets of data ranging from 2000 to 2006 split into monthly totals One set relates to Units produced per month; the other to units sold per month I want to show both sets of data in a Pivot table together on one linear pivot chart. Anybody know how I can manage this ? thanks |
#4
|
|||
|
|||
show results of two pivot charts
Well, then you changed your requirements from your original post in which you
stated you wanted a single chart: "I want to show both sets of data in a Pivot table together on one linear pivot chart." If all you want is to get two charts on one page, create the separate PivotTables and charts. Then, for each chart, set the location to be the same worksheet (use Chart | Location...). Now, both charts will be objects in the same worksheet and you can adjust their appearance to suit your taste. -- Regards, Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach "johnjmcdermott" wrote: Thank you for your reply, Tushar. Unfortunately the result of your answer is to consolidate both ranges of data and show the accumulated result as a single linear chart. My requirement is to show both data ranges as separate linear graphs on the one page so that comparisons can be shown , graphically, between the two ranges. Thank you for your hepl and perhaps I may not have expressed my problem fully in the first instance. John Mc Dermott "johnjmcdermott" wrote: I have two sets of data ranging from 2000 to 2006 split into monthly totals One set relates to Units produced per month; the other to units sold per month I want to show both sets of data in a Pivot table together on one linear pivot chart. Anybody know how I can manage this ? thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to show month end balances in a Pivot Table | stevep | General Discussion | 1 | January 11th, 2006 03:15 PM |
How to show the "fields list button" when the users open the pivot table ? | Martin | General Discussion | 0 | November 22nd, 2005 11:33 AM |
Using Pivot Charts, how to hide field values in second level filters? | elrao | General Discussion | 1 | June 17th, 2005 10:22 AM |
data table in pivot charts | Thomas | General Discussion | 3 | February 17th, 2005 04:41 PM |
Resizing Pivot Charts and pasting into Word documents | Stan | Charts and Charting | 7 | October 27th, 2003 12:12 AM |