Copying a Chart's Formatting to Another Chart

After you set up a chart with all the formatting you need, you can apply that formatting to another chart by using Copy and Paste. Follow these steps:

1. Click the formatted chart to select its chart area.
2. Right-click the border of the chart, then click Copy on the context menu to copy the chart and its formatting to the Clipboard.
3. Go to the sheet that contains the chart onto which you want to paste the formatting.
4. Choose Home Clipboard Paste Paste Special to display the Paste Special dialog box shown in Figure 7–14.
   

   Figure 7–14. In the Paste Special dialog box, select the Formats option button to paste just the formatting from one chart onto another chart.

5. Select the Formats option button.
6. Click the OK button to close the Paste Special dialog box. Excel applies the formatting to the chart.