If you know Format Painter, the on top of your mind solution should be using Format Painter to copy Chart Formats to other charts. However, it doesn’t work… 😦
No worries. Copy and Paste comes to recuse!! Really?!
Of course. Just that you cannot do it with keyboard shortcuts.
You may download a Sample File to follow along.
Let’s watch it in action:
Tip: If you are dealing with multiple charts, don’t forget our shortcut friend F4 that repeats your last action.
A reminder: The popular Excel Dashboard course by Mynda Treacy is closing soon. If you wish to uplift your Excel Dashboard skills, don’t miss it.
Disclosure: I make a small commission (at no additional costs to you) for students who join Mynda’s course via my site, but as you know I don’t just recommend anything and everything. It has to be of outstanding quality and value, and something I can genuinely recommend. After all, if it doesn’t live up to what I’ve promised you’ll think poorly of me too and I don’t want that. Oh, and just watching the course videos won’t transform your career, you have to actually put it into practice, as if reading a cookbook won’t make you a chef.
Did you use generic keyboard shortcuts?? You have to use the buttons in the ribbon as demonstrated in the video. Pls try again.
LikeLike
Hi, it doesn’t work. Past Special gives me the options Paste: Picture (PNG)/Picture (JPEG)/ etc. No format…
LikeLike