pivot field autoselection

[BorisS]

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.

 

[Dave Peterson]

Debra Dalgleish has some sample code for printing.
http://contextures.com/xlPivot09.html#Page

 

[BorisS]

I think I follow the basic logic, but not sure what I would substitute for
pivotchart, and where I would insert the code that I have which would, before
moving to the next item, change some of the formatting and then grab the
chart. Thanks if you can assist further.

 

[BorisS]

Also, is there any inherant function that can take an activesheet's
pivotchart, and figure out where the underlying pivottable is? If so, then I
could use the code to figure out which table is driving it, and rather than
using the activesheet table, I'd use the chart to define what the reference
sheet and table are, and change those pivot items.

Still not sure how to do multiple page fields, but I could probably live
without that if there's absolutely no way to do it.

Thx.