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

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.