Excel Pivot Table & Chart

Hello Tereesa,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding making Excel PivotTables and PivotCharts work independantly.

There are 2 ways I know of achieving what you want. I will show you a way that I have used myself and if this works for you... great! The second way is a bit way out so I won't go there.

First of all create your PivotTable without a PivotChart. Place your fields into the sections you require and then make a copy of the sheet. The easiest way I know to do this is to press and hold the CTRL key down and click on the sheet name and drag to the right or left until you see a black triangle. Let go the mouse button and you have created a copy of the sheet.

You should now have 2 PivotTables.

Rename each sheet to identify which is which and then create a PivotChart in each sheet.

Now perform a few filters on one PivotTable only and the PivotChart in that sheet will be amended to reflect the changes. Have a look at the other PivotChart... it should still be the same. From this you can see that to prevent a PivotChart from reflecting changes you make in a PivotTable you need to use a copy of the PivotTable. If you don't need the second PivotChart simply delete it.

So now you have two PivotTables and one PivotChart. The PivotChart being controlled by only one of the PivotTables.

Unfortunately when you create a PivotChart from a PivotTable there is no way to separate them when you perform filters or calculations etc. The way I have described above is probably the best work around.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer