Ive been asked to make multiple charts. I have a pivot table to supply the data and I can change the filters and have the chart dynamically update fine. What I would like to do is copy the pivot chart and paste it on the same sheet and then alter the filters. When I try this, both the original chart and the new chart update. Is there a way to only update the new chart? I can copy the pivot table to a picture to get the same result but I was looking for have all charts dynamic without having to create a bunch of pivot tables.