Pivot Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How I can set dynamic pivot table ONLY when I have enough data point 1
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Using VBA to create charts 1
Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA? 4
create a pivot table and chart from a named range 1
create pivot chart in vbscript 1
Changing pivot filter causes chart type to change! Why? 2
Pivot Tables 1

Back
Top