Excel: How To Copy Formatting From One Chart To Another

Contributor Icon Contributed by Rob Rogers  
Tag Icon Tagged: Microsoft Excel  

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 Edit – Paste 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.

 

5 Comments -


  1. Exploding said on April 8, 2011

    needs updated for 2007

  2. davak said on April 8, 2011

    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.

  3. Rob Rogers said on April 8, 2011

    Included the updates for Excel 2007/2010.

  4. David Kirk - Founder/Editor said on April 8, 2011

    Thanks! You da man… as always.

  5. Anand said on November 3, 2011

    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.

 

RSS feed for comments on this post. TrackBack URL

Leave a comment -