Copy chart formats to other charts in Excel

Excel tip - Copy and Paste Chart Format

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.

Excel Dashboard Course

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.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , . Bookmark the permalink.

2 Responses to Copy chart formats to other charts in Excel

  1. MF says:

    Did you use generic keyboard shortcuts?? You have to use the buttons in the ribbon as demonstrated in the video. Pls try again.


  2. djgizbo says:

    Hi, it doesn’t work. Past Special gives me the options Paste: Picture (PNG)/Picture (JPEG)/ etc. No format…


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.