Forum Discussion
Excel Pivot Table Filter and Label Formatting
Johnbda First of all, the Filter button on the top right only appears for the chart selected.
With Pivot charts you can copy the format of one to another by selecting the first pivot chart. Press Ctrl-C. Select the second pivot chart and press Ctrl-V. So, if you copy the pivot table and create you second pivot chart on that one, then you can copy the exact format from the first one.
Riny_van_Eekelen Thanks for your response. My apologies, I neglected to mention that I was aware of the fact that the buttons wouldn't show unless the chart was selected, and being a static pic, that wasn't apparent. When the first chart was selected, the filter button did not appear as it did in the second one.
Also, the chart on the right is a direct result of copy/paste (Control C/V), which is why I don't understand how it became formatted differently.
Johnbda Can't really tell why the filter buttons don't appear in the first chart, but perhaps a good idea to upload your file, provide it doesn't contain any confidential information, to determine why the formatting is off.
Riny_van_Eekelen Thanks again for responding, as it turns out, I've been asked to go in a different direction for presenting the data, but I'm still very curious about what happened and why. I won't upload the document, however I would point out that the initial chart copied shows a box to check for "Multi-level Category Levels" and the copied chart does not.
Initial Chart
Copied Chart
Above you can also see with the charts selected, the first chart does not have the filter button, whereas the second does.