Monday, August 15, 2005

Copying/Pasting Excel Charts Into Other Programs

One of the valuable "hidden" tricks in Excel is how to copy a chart as an image so that when pasting into another program, it will paste as an image rather than an Excel object (which generally saves the entire workbook along with the chart). Here's the trick:

Hold down the Shift key as you select the Edit menu. This will make the "Copy as Picture..." option available.

This will work for nearly any type of selection, including a group of cells (when copying a table for example). Other office programs (such as PowerPoint) have the "Paste Special..." option that allows you to paste as a picture, which is another way to accomplish the same thing.

No comments :