I have a pivot table and I want to create three different graphs that change based on what is selected in the pivot table. For example, when I select a specific nusring unit to have their data displayed, i want all of the graphs to change to that unit.
I have tried creating a new pivot chart and when it asks if i want to use an existing table, I select yes but it still creates a new sheet for a new table.
Or is there a way to make the current charts I have pull the data from the original sheet? Currently I have a different table for each chart. But I have to change all the fields on each table to make the graphs the same.
I basically want to link all the charts to one pivot table.
Thanks!
Bookmarks