I have captured a macro when I made the cutom changes to my pivot chart. I
would like to run it automatically when the user changes the data point. I
mean my chart showing reps data by month, when selecting different rep I
would like to run the macro automatically. Is it possible. How do I do that.
Any help, really appreciate.

Thanks