A Microsoft Excel forum. ExcelBanter

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.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

two Pivot Tables One pivot chart



 
 
Thread Tools Display Modes
  #1  
Old March 3rd 06, 10:40 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default two Pivot Tables One pivot chart


hi, I have a pivot table that shows the % difference for a groups
forecasted results and a pivot table that shows % difference for actual
results.

Is there any way to have both of these records sets shown in one table
and then one chart without going down the path of multiple
consolidation ranges? I'm not particually well versed in this area and
following this path does not show the data as i would like it e.g I
need to see the actual values of the two pivot tables rather than a
count or sum of them.


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=518636

Ads
  #2  
Old March 3rd 06, 02:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default two Pivot Tables One pivot chart


I don't fully understand your query but if for January the target was
100, the forecast was 97 and the actual was 95, your 2 pivot tables
presumably show
-3% and -5%


I suggest you ditch the pivot tables and replace them with 1 sumproduct
table

=sumproduct((a1:a5=deptA)*(b1:b5="january")*(c1:c5 >0)) is the type of
equation assuming your %diff_forecast_from_target figures are in column
C


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=518636

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Pivot chart issue James Charts and Charting in Excel 8 September 13th 05 12:35 PM
Pivot Chart - default chart type Rav99 Excel Discussion (Misc queries) 4 September 6th 05 01:20 AM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 12:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.