Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
johnb
 
Posts: n/a
Default Pivottable

I have a list of Parts (1000's) in rows and dates (dd/mm/yyy) across the
cols. I need to view several years of data grouped by Qtrs and Months. As
Excel XP is currently limited to 256 cols It will not complete the
pivottable. How can I group all my data on 1 worksheet? I hope this is clear.

reagrds
johnb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivottable data field nc Excel Discussion (Misc queries) 0 September 30th 05 12:44 PM
Sorting in PivotTable Aaron Howe Excel Discussion (Misc queries) 5 July 12th 05 09:49 PM
Pivottable Dates JayBee Excel Discussion (Misc queries) 5 January 15th 05 08:43 PM
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 03:52 PM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 11:16 AM.

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

About Us

"It's about Microsoft Excel"