A quick way to duplicate all of the custom chart formatting

Excel 365 2016 2013 2010 2007
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 choose Edit -> Copy. Click your new chart and choose Edit -> Paste Special. In the Paste Special dialog box, select Formats.

    Paste Special in Excel 2003
  • Copy the chart: Hold down Ctrl while you click the original chart and drag.

    This creates an exact copy of your chart. Then use the Chart -> Source Data dialog box to specify the data for the new chart.

    Source Data in Excel 2003
  • Create a user-defined chart type: Select your chart; then, choose Chart -> Chart Type. Click the Custom Types tab and select the User-Defined option.

    Click the Add button and then provide a name and description. When you create your next chart, use this custom chart type.

    Custom Type in Excel 2003

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