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:
- Click the formatted chart to select its chart area.
- Right-click the border of the chart, then click Copy on the context menu to copy the chart and its formatting to the Clipboard.
- Go to the sheet that contains the chart onto which you want to paste the formatting.
Paste Special to display the Paste Special dialog box shown ...