Hello

If I have a pivot chart that could have any combination of page fields, row fields, column fields, data fields. How can i clear them all (without deleting the chart) using a macro. So once the macro has been run the chart is empty ready to recieve new fields. i take it you must use a loop

Thanks in advance
James

Try something like this

Dim f As PivotFiel
For Each f In Chart1.PivotLayout.PivotField
f.Orientation = xlHidde
Nex

-Brad