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.