Forum Discussion
Excel Pivot Table Filter and Label Formatting
Excel 2016 Images of 2 separate workbooks, each with a data table, pivot table and pivot chart, the one on the right created by copy & paste of the one on the left. The one on the right ch...
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.