A quick way to duplicate all of the custom chart formatting

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

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.