LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 191
Default pivot field autoselection

Second try...

I'd like to have something that cycles through the page fields in a
pivorchart. In other words, if there are 3 items in page field 1, and 4 in
page field 2, I'd want it to take:

field 1 field 2
"all" "all"
"all" item 1
"all" item 2
"all" item 3
item 1 "all"
item 1 1st item

etc., until it gets through each of the first field and the second field. I
would combine this with other code which, inbetween the cycle to the next
option, would grab the chart and paste it elsewhere, but all I need is to
cycle through the page fields in the above fashion.

Kind regards.

--
Boris
 
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
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
Unable to change field settings in calculated field in a pivot tab Mike Excel Discussion (Misc queries) 0 September 25th 06 07:45 PM
Autoselection of Spreadsheet for liking Spreadsheet Linking Flexibility Excel Discussion (Misc queries) 0 May 29th 06 07:19 PM
PivotTable ColumnFields AutoSelection Bob[_64_] Excel Programming 0 January 13th 05 01:50 AM
autoselection in a pivot table thrava Excel Programming 0 February 5th 04 09:22 PM


All times are GMT +1. The time now is 06:12 PM.

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"