How to create a second pivot chart

Lets take a look.

Here we have a simple pivot table and pivot chart already set up.

As always, any change to the pivot table is reflected in the pivot chart, and vice versa.

Lets say we want to add a second chart using the same data.

We can easily copy and paste the existing chart to another location to create another copy.

This is because both charts are linked to the same pivot table.

In some cases, this might be what you need.

Lets delete the second chart and have another go.

Well go ahead and put the chart on a new worksheet.

The result is a pivot table and pivot chart that are independent of the original chart.

If we check the original pivot chart and table, we can see that they are unchanged.

The sheet and pivot table will be listed after the workbook name.