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