I've created (through copy and paste) 12 pivot charts (one for each month for my annual data) that are linked to the same table. Using the filter options on each chart I've been attempting to set each chart to show the data for an individual month, but every time I select a specific month for one of the charts, Excel adjusts all 12 charts to the same month. Is there a way to lock each individual chart into a certain filter? Or do I need to go about creating the charts in a different way? Thanks.