A quick way to duplicate all of the custom chart formatting

Excel 365 2016 2013 2007 2003
Creation of a large number of visually consistent charts to represent different data is a time consuming and error prone task, unless you know how to copy formatting between charts.

You have several options:

  • Copy the formatting: Create a standard chart with the default formatting.
    Then select your original chart and on the Home tab, in the Clipboard group, choose Copy (or press Ctrl+C).
    Clipboard in Excel 2010

    Click your new chart and choose Paste Special on the Home tab, in the Clipboard group.

    Clipboard in Excel 2010

    In the Paste Special dialog box, select Formats.

    Paste Special in Excel 2010
  • Copy the chart: Hold down Ctrl while you click the original chart and drag.
    This creates an exact copy of your chart. Then on the Design tab, in the Data group, click the Select Data button:
    Data in Excel 2010

    In the Select Data Source dialog box specify the data for the new chart.

    Select Data Source in Excel 2010

    You can choose Select Data Source dialog box also from popup menu:

    Data in Excel 2010
  • Create a template: Select your original chart; then, on the Design tab, in the Type group, choose Save As Template.
    Type in Excel 2010

    To create the chart from the template, on the Design tab, in the Type group, choose Change Chart Type.

    In the Change Chart Type dialog box, click Templates, and then click the chart template that you want to use in the second box:

    Template in Excel 2010

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.