A quick way to duplicate all of the custom chart formatting
Excel
2003
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.
- 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.
- 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.