Does anyone know the macro that will automatically refresh my pivot chart? I wrote one for the pivot table but am having trouble refreshing the chart. Thanks!!