I have a macro that prints sets of Pivot charts, based on a number of Fields. For example:
ActiveChart.PivotLayout.PivotTable.PivotFields("Department").CurrentPage = "GI"
this sets the Pivot Field called "Department" to the value "GI" and then the macro prints the chart. I'd like to use variable data for the Date Pivot Field, so that I can set Pivot Field called "Date" to be "Today(), Today()-1, Today()-2...."
Is there a way to do this in the macro?
Thanks,
-Miles
ActiveChart.PivotLayout.PivotTable.PivotFields("Department").CurrentPage = "GI"
this sets the Pivot Field called "Department" to the value "GI" and then the macro prints the chart. I'd like to use variable data for the Date Pivot Field, so that I can set Pivot Field called "Date" to be "Today(), Today()-1, Today()-2...."
Is there a way to do this in the macro?
Thanks,
-Miles