How to Copy Formatting from One Excel Chart to Another
If you have created a new chart and want it to have the new chart have the format of an existing Excel spreadsheet, this article will explain how to do so.
How To Copy Excel Chart Formatting Between Documents
1. Open both the new chart and the chart you want to duplicate in format.
2. Left click once on the chart whose format is to be duplicated. To copy the format, you can either select "Edit - Copy" from the menu bar or use "Control" and "C" buttons in combination.
3. From the Copy options, select "Edit - Paste Special". The "Paste Special Dialog" box opens. Click on the "Formats" button. Then click on "OK".
4. When you paste special in this way, the formatting of the origination chart copy to the destination chart.
Another option is to save the document with the chart under a new name and then modify the spreadsheet to include the new information or data.
More by this Author
What is IT engineering? What do IT engineers do? What are the major IT engineering certifications?
You can no longer use POP to download email from a private server to Google Mail, Gmail. Here are your options when Google Mail will not accept self-signed SSL certificates.
What is covered in the Lifestyles Unlimited two day course? What are the pros and cons of the Lifestyles Unlimited 2 day class?
No comments yet.