Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot field autoselection
Debra Dalgleish has some sample code for printing.
http://contextures.com/xlPivot09.html#Page BorisS wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot field autoselection
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. -- Boris "Dave Peterson" wrote: Debra Dalgleish has some sample code for printing. http://contextures.com/xlPivot09.html#Page BorisS wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot field autoselection
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. -- Boris "Dave Peterson" wrote: Debra Dalgleish has some sample code for printing. http://contextures.com/xlPivot09.html#Page BorisS wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Autoselection of Spreadsheet for liking | Excel Discussion (Misc queries) | |||
PivotTable ColumnFields AutoSelection | Excel Programming | |||
autoselection in a pivot table | Excel Programming |