This worksheet has 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.

Let’s say we want to add a second chart using the same data.

So, this won’t work if we want different views of the same data.

I’ll delete this chart, and let’s have another go.

For example, I can summarize total sales by product.