Hi all, so I am using Pivot Tables to create charts (Pie, Bar, Donut...!) on Excel 2016, from the data.
I have formatted them rather nicely, but whenever I create a new one, is there a way to copy the formatting of one to another?
I have tried Ctrl+C, but no paste special (format) dialogue box appears?
I see there is a Format Painter and I did one, somehow, but I can't seem to do anymore?
So tedious having to remember all of the formats each time, hoping somebody will know a short cut!
Thanks.
I have formatted them rather nicely, but whenever I create a new one, is there a way to copy the formatting of one to another?
I have tried Ctrl+C, but no paste special (format) dialogue box appears?
I see there is a Format Painter and I did one, somehow, but I can't seem to do anymore?
So tedious having to remember all of the formats each time, hoping somebody will know a short cut!
Thanks.