Excel: How To Copy Formatting From One Chart To Another

After you have finished your customization of a chart, you can easily copy the formatting to another chart. Updated to add mac data and screenshot.


1. Select the chart area of the formatted chart and press CTRL-C

2. Select the chart you wish to apply the new format to.

3. Select EditPaste Special from the toolbar

4. In the Paste Special dialogue box, select the Formats option

5. Click OK to apply the format to the chart

Editor’s note:

This similar process works in Excel 2008 for Mac:

In Excel 2007/2010:

1. Select the chart area of the formatted chart and press CTRL+C

2. Select the chart you wish to apply the new format to.

3. Go to the Home tab on the Ribbon.

4. Go to the Clipboard section, click the downward pointing arrow, beneath the Paste icon.

5. Select Paste Special.

6. Select the Formats radio button.

7. Click the OK button.

 

About Rob Rogers

Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
View more articles by Rob Rogers

The Conversation

Follow the reactions below and share your own thoughts.

  • Name

    That was great, thank you very much for that! Very useful!

  • Exploding

    needs updated for 2007

    • 2007 is different? I’ll ask Rob to take a look at it. I added a screenshot from my Mac excel setup that shows that it’s essentially the same.

    • Included the updates for Excel 2007/2010.

  • Anand

    Thanks a lot !!.
    I was looking for this for quite sometime and always spent lot of time to get the same format especially while doing multiple chart presentations.

  • Karyn

    Got excel 2013 (not by choice) and it crashes every time I try. Oh microsoft. =(

  • subs

    Are you kidding me? Is there really no format painter tool on the Mac version of Excel? Either I can’t find it or it’s not there. FAIL.

  • Dean

    Works perfectly in Excel 2013 – awesome!!