A quick way to duplicate all of the custom chart formatting

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).

  

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

  

  In the Paste Special dialog box, select Formats.

  
• 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:

  

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

  

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

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

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

  

  To create the chart from the template, on the Design tab, in the Type group, choose Change Chart Type (or select Change Chart Type in the popup menu).

  In the Change Chart Type dialog box, on the Templates tab, select the chart template that you want to use:

  

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