Prevent Excel from filtering copied worksheets

Hi,

I've created a worksheet with pivots and a worksheet with a dashboard. Graphs in the dashboard are based on the pivots. Now I copied my dashboard, in order to create separate dashboards for different departments. These dashboards consist of the same graphs but with different filters. However, when I change the filter for a graph in one of the copied worksheets, the graph in the original worksheet changes too. How do I prevent Excel from doing that?

Thanks in advance!

Twan

Hi JeteMc,

Thanks a lot. I think the problem is that I tried to create different graphs from the same Pivot. By applying a filter on a graph, I applied a filter on the Pivot. Since the other graphs are coming from the same Pivot, they changed along. I don't think there is a way to get around this, other than creating different Pivots.