Please forgive if this question has been asked and answered a lot. I tried to do a search, but, egads, found myself immersed in information that was really interesting, but not on topic (similar to how I find myself constantly lost in Wikipedia)!

Would anyone know how to maintain data labels (like percentages) on a pie or bar chart as well as secondary axis on a pivot table? It seems once you change the filter for different account information, you also need go through a series of steps to re-link the labels.