A quick way to duplicate all of the custom chart formatting

Excel 365 2013 2010 2007 2003
The 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).
    Copy button in Excel 2016

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

    Clipboard in Excel 2016

    In the Paste Special dialog box, select Formats:

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

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

    Select Data Source in Excel 2016

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

    Select Data in popup menu Excel 2016
  • Create a template: Select your original chart; then choose Save as Template... in the popup menu:
    Type in Excel 2016

    In the Save Chart Template dialog box, select the location and type the name of the new template:

    Template in Excel 2016

    To create the chart from the template, under Chart Tools, 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.

See also this tip in French: Comment dupliquer tout le formatage de graphique personnalisé.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more